I need to Join 3 tables.

Question

I have following tables tbl1 (empID Name ctNo) tbl2 (salID empID salry) tbl3 (histryID salDate empID salID) Expect Output (empIDNamesalarySalary_Date) For all employees. dont want to display employees all the salary date. Display last salaryDate. By using Partitiion by or Selfjoin methods. Thank You Get back soon Friends.

Abdu Rafeeq · Answer

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 )

Parameswaran R · Answer

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 Powar · Answer

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