RelationalDBDesign
RedhatLinuxSys Seomining
prev
Course navigation
Use a sub-SELECT statement
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".