I need to Join 3 tables.

select name,salDate,salr from tbl1

inner join tbl2 on tbl2.empid=tbl1.empid

inner join tbl3 on tbl3.empid=tbl2.empid

where salDate=(select MAX(salDate) from tbl3)

Want to join based on each employee last salary_Date only. Your query display employees all salary_Date columns. It should be display last salary_Date is my Requirement.. Ranjit Powar

Ranjit Powar10y ago

with temp( empID,Salary_Date)

as(select empID,MAX(Salary_Date)

from tbl3

group by empID

)

Select tbl1.empID,tbl1.Name,tbl2.salary, temp.Salary_Date

From tbl1 Inner Join tbl2 on tbl1. empID=tbl2.empID

Inner Join temp on temp. empID=tbl2.empID