Use SQL query to list Which employees in tblEmployee have not accepted a work order in tblWorkOrder?
Fantastic news! We've Found the answer you've been seeking!
Question:
Use SQL query to list Which employees in tblEmployee have not accepted a work order in tblWorkOrder? The ManagerLastName and ManagerFirstName columns are the EmpLastName and EmpFirstName of the manager for the employee. Hint: This query requires two copies of tblEmployee: one to serve as the employee and the other to serve as the manager. Here is the result table:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: