how to get data from two table

[Amit Rai]

let us suppose there are two tables namely 'employee' and 'department'. In employee table columns are emp_id PK and emp_name.In department table columns are dep_id as FK(emp_id),sala ry,month; here one id contain multiple months salary.
Now,
we have to find out the name,salary of the TOP 3 employee whose salary is maximum in his all months salary.

[Jerry Winston]

How does one dept_id row have multiple months pay? Does your dept table look like this:

dept_id,   emp_id,   salary,   month1,  month2,   month3,  month4,  ...

Can you give us a sample data set?

[MrMancunian]

I'm pretty sure this is a school assignment. Please read our Guidelines on posting Homework or Coursework questions.

Steven

[NeoPa]

Good spot Steven. It is indeed I'm sure. I've closed the thread to further posting.