help on query needed please

I have the following problem. I will be very thankful if someone could tell me the solution:
I need to display ename, mgr, sal, grade and dname through an sql query. The data should be taken from four tables. I will be thankful if any one can help me.Hi,

you havent mentioned anything abt the tables.
Anywayz... a sample query would be like
select ename, mgr, sal, grade, dname
from table1, table2 , table3 , table4 where
condition

The conditon is what is important and I cannot guess
it without the tables

Good luck
Usha