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 (empID,Name,salary,Salary_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.