Help returning current job title

[rosscortb]

Hello,

I have employee ID, Employee Name, Position ID and Start Date and End Date

I want to return the current Position
For example.



ID Name Position ID Start End
1 John 1 01/04/2014 02/04/2019
1 John 2 03/04/2019

So far I have

SELECT Employee.ID, Employee.Employee_Name, Position_History.Position_ID
FROM Employee INNER JOIN Position_History ON Employee.ID = Position_History.Employee_ID
ORDER BY Employee.Employee_Name, Position_History.Start_Date;

Thanks

Ross

[rpeare]

not enough information here.

If you are just trying to return their most recent position just use the IS NULL criteria on the END date. As long as you don't have multiple positions open for a single person it should do what you want.

[rosscortb]

Thanks. Spot on

[rpeare]

mark your thread solved please!