Purchase Solution

A SQL Query to List Customers

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Statement for Grades

    Using the two tables from #8, write an SQL statement that uses a SUB QUERY and the IN keyword to return the First Name of the customers who live in the state of MI. 10. Tell why the following SQL statement is incorrect.

  • How to Use SQL on Premiere Products

    b.Write an SQL query to retrieve the number and name of all customers in the SmallCust view with balances that exceed their credit limits. c.Convert the query you wrote in Question 1b to the query that the DBMS will actually execute.

  • ACCESS 2000

    Create the CUSTOMERS table. To create the customers table use the below SQL code. Copy it into the SQL view of a new query to run it: To get into a query's "SQL view" in Access: 1.

  • Summarizing query and explaining functions and grouping

    Basic SQL clauses and keywords used to aggregate and present data are in the list below: Clause Purpose Example SELECT Used to specify what fields will be included in the query result. This clause is always found in SQL query statements.

  • Programming SQL Statements to Retrieve Data from a Database

    Modify the first query to list the orders with customer details, but include all customers even if they have not placed an order. - 832 rows returned. 5.

  • SQL Queries

    152446 Query Statement for to query DATA Use only one SQL statement for each task. Submit the SQL statement(s) that you would use to accomplish each task. 1.Find all employees whose name starts with either an S, s, A, a, T, or t.

  • SQL Code - Working with Additional Database Objects

    Using a single query, query the PUBNUM_SEQ to determine what both the current sequence number is and the next sequence number will be. 7. Create a unique index on the combined columns ORDER# and CUSTOMER# in the BOOK_ORDER table.

  • Writing query for SQL using NESTED-SELECT statement

    285915 Writing query for SQL using NESTED-SELECT statement I have a list of incomes (in column labeled Income) in a table labeled Jobs. I need to find the second highest number in the income column.

  • MS SQL SERVER 2003

    Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection (use Store Name to restrict the data). 2.

View More Related Solutions