Imal Upalakshitha
asked on
SQL database
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
SELECT tbl_PoAproval.FistAproval, tbl_PoAproval.FistAprovalD ate, tbl_PoAproval.SecondAprova l, tbl_PoAproval.SecondAprova lDate, tbl_PoAproval.ThirdAproval Date,
tbl_PoAproval.ThirdAproval , tbl_PoAproval.PONumber, Employees.FirstName
FROM tbl_PoAproval INNER JOIN
Employees ON tbl_PoAproval.FistAproval = Employees.EmployeeID
WHERE (tbl_PoAproval.PONumber = 'WA-011075')
image001.png
Can you please help ……….. please see attached image
SELECT tbl_PoAproval.FistAproval,
tbl_PoAproval.ThirdAproval
FROM tbl_PoAproval INNER JOIN
Employees ON tbl_PoAproval.FistAproval = Employees.EmployeeID
WHERE (tbl_PoAproval.PONumber = 'WA-011075')
image001.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER