Select Statement  «Prev 

Use a sub-SELECT statement in SQL

Objective: Create a sub-SELECT statement using the IN keyword.
Given the following two tables:
  1. MyCustomers
  2. MyOrders

Table name: MyCustomers

CustomerID Lastname Firstname Address City State ZipCode Classification

Table name: MyOrders

OrderID CustomerID OrderAmount
Create a sub-SELECT statement that will show the OrderAmounts for all Customers with a classification of "A".