lecture notes

three steps in the wizard
1) choose your table(s)
2) choose your field(s)
3) name the query

THEN, you will likely need to go to Design View
there, you will choose your criteria, sorting order, etc.

SELECT Accounts.CID, Accounts.BID, Accounts.Balance
FROM Accounts;

SELECT CID, BID, Balance FROM Accounts WHERE BID="B5";

SELECT Accounts.CID, Accounts.Balance, Branch.Location, Customers.FirstName, Customers.LastName
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BID = Accounts.BID) ON Customers.CID = Accounts.CID
WHERE (((Branch.Location)="Central"))
ORDER BY Accounts.AID;

HW: Not chapter 1. yes, chapter 2, access, practice exercises 1-3

Cartesian Product
Select, Customers.CID, FirstName, LastName
OrderID, OrderDate,Orders.CID,Cost
From Customers, Orders;

SELECT * From Customers, Accounts
WHERE Customers.CID = Accounts.CID
This is called an INNER JOIN


SELECT * From Customers INNER JOIN Accounts
ON Customers.CID = Accounts.CID