Explore BrainMass

SQL query

I have attached a Word document 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.


Solution Preview

Use Northwind

Select Distinct ...

Solution Summary

It provides SQL query to implement the required tasks. The response received a '5/5' rating from the student who originally posted the questions.