Using Joins
Sub Queries
Action Queries
Full Text Searches

Using Joins

1. Inner Joins
   SELECT Company-name, OrderID, OrderDate
   FROM Customers INNER JOIN Orders
   ON Customers.CustomerID = Order.CustomerID
   WHERE OrderDate = ‘ 5 / 6 / 98 ‘

or

SELECT Company-name, OrderID, OrderDate
FROM Customers as c INNER JOIN Orders as o
ON c.CustomerID = o.CustomerID
WHERE OrderDate = ‘ 5 / 6 / 98 ‘

SELECT Company-name, OrderDate, SUM(UnitPrice x Quantity)
FROM Customers as c INNER JOIN Orders as o
ON c.CustomerID = o.CustomerID
HAVING

2. Outer Joins
3. Self Joins