Defining the employees tables


Discuss the below:

Q: Defining the dbo.Orders and dbo.Employees tables (Northwind database). The needed query is: List the EmployeeID, LastName, and FirstName of all employees who did not take an order between March 1 and March 7, 1997. USe an outer join. You must include the condition on OrderDate in the ON clause of the outer join.

Attachment:- Db tables.rar

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Defining the employees tables
Reference No:- TGS01939108

Now Priced at $25 (50% Discount)

Recommended (96%)

Rated (4.8/5)