Explore BrainMass

Explore BrainMass

    A SQL Query to List Customers

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com March 4, 2021, 8:16 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/sql-query-list-customers-156143

    Attachments

    Solution Summary

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

    $2.49

    ADVERTISEMENT