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
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:
1 2 234 3 5 6 7 8 0000 EmplD EmpLastName EmpFirstName ManagerLastName ManagerFirstName E10003 Shamsudeen Mumtaz E10015 Sam E10026 Lieu E10042 Juliette E10055 E10056 Chen E10085 Wong E10087 Agarwal E10101 Dabiri Fetters Nguyn Van Meter Huang Hai Jun John Thomas Aarav Dilshad NULL Shamsudeen Fetters Nguyen NULL Fetters Nguyen Nguyen Nguyen NULL Mumtaz Sam Lieu NULL Sam Lieu Lieu Lieu
Step by Step Solution
3.31 Rating (151 Votes )
There are 3 Steps involved in it
To achieve this you can use a selfjoin on the tblemployee table to match employees wit... View full answer
Get step-by-step solutions from verified subject matter experts
