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 

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

1 Expert Approved Answer
Step: 1 Unlock

To achieve this you can use a selfjoin on the tblemployee table to match employees wit... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!