Hi
Thanks for that hint ;)
I am getting one problem now which is some employees havent got a salery and its not showing those departments. :confused: I have to state is null but i am not sure were i need to state it.
Heres what ive done. So far
select dept.deptno, dname, loc
from...