SQL Subqueries Example

This example lists the name and contact of every customer who placed an order in the second quarter of 1995.

SELECT ContactName, CompanyName, ContactTitle, Phone
FROM Customers
WHERE CustomerID IN 
(SELECT CustomerID 
FROM Orders
WHERE OrderDate Between #04/1/95# And #07/1/95#);