I need to know how to select the first time, Second time and Third time PO approval employee name. when I tred as below , but output show EmployeeID only.
Can you please help ……….. please see attached image
, tbl_PoAproval.PONumber, Employees.FirstName
FROM tbl_PoAproval INNER JOIN
Employees ON tbl_PoAproval.FistAproval = Employees.EmployeeID
WHERE (tbl_PoAproval.PONumber = 'WA-011075')