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