Explore BrainMass

A SQL Query to List Customers

A SQL query to list customers who did not have an order between 03/01/97 and 03/07/97

I have attached the two tables to be used. The query needs to output only those employees (employeeID, FirstName, LastName) if there is not an order date bewtween 03/01/1997 and 03/07/97.I need a sub-query used and no joins. I need the employee only to show up once.


Solution Summary

It shows how to use a SQL query to list customers.