I have a work order worker history file. Each time the assigned worker/vendor is changed a new record is generated. I need to find the last worker assigned. I have an employee table that just lists employees and a vendor table for vendors.
I know if I use
SELECT woHist.wo_id, woHist.worker_id, emp.em_name, woHist.date_assigned
FROM woHist INNER JOIN emp on woHist.worker_ID = emp.em_id
I will get work orders and the list of assigned workers (no vendors)
How do I modify that to get the last (latest date assigned)