Explore BrainMass
Share

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.

© BrainMass Inc. brainmass.com June 24, 2018, 12:57 pm ad1c9bdddf

Attachments

Solution Preview

Use Northwind
GO

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.

$2.19