| CustNum | CustName | Street | City | State | Zip |
| 501 | City of Spokane | 123 Some St. | Spokane | WA | 99003 |
| 502 | Adams Steel | 456 Another St. | San Diego | CA | 92111 |
| 505 | Fender America | 888 La Mesa St. | Fullerton | CA | 91501 |
| SupplierNum | QOH | Cost | UnitPrice | UnitWeight | SKU | Description |
| 82 | 10 | ¤ 24.35 | ¤ 38.35 | 0.7 | HC1 | WPF Toolkit |
| 82 | 10 | ¤ 29.75 | ¤ 42.42 | 0.8 | TRF1 | TCP for IBM |
| 81 | 144 | ¤ 1.75 | ¤ 3.15 | 1.0 | 1001 | QuickBooks Pro |
| 81 | 12 | ¤ 5.55 | ¤ 7.50 | 2.5 | 1002 | TaxCalc |
| 82 | 10 | ¤ 275.00 | ¤ 495.00 | 0.5 | RD1 | Report Downloader |
| 82 | 10 | ¤ 165.95 | ¤ 295.33 | 0.5 | SFD1 | Smart File Downloader |
| CustNum | OrderDate | Status | OrderNum |
| 501 | 10/6/14 | Open | 1920 |
| 502 | 10/8/14 | Open | 1921 |
| 502 | 10/13/14 | Open | 1922 |
| 505 | 10/10/17 | Open | 1923 |
| OrderNum | LineNum | SKU | OrdQty |
| 1920 | 1 | RD1 | 1 |
| 1920 | 2 | SFD1 | 2 |
| 1921 | 1 | HC1 | 1 |
| 1921 | 2 | TRF1 | 1 |
| 1921 | 3 | RD1 | 3 |
| 1922 | 1 | RD1 | 1 |
| 1922 | 2 | HC1 | 1 |
| 1923 | 1 | RD1 | 3 |
| CompanyName | Contact | Street | City | State | Zip | Phone1 | SupplierNum |
| KDP Europe | Kevin Passey | 44 Detro Common | Blackpool | Manchester | 3G6HY5 | 60 788 91004 | 81 |
| Evergreen Interactive | Ellen Endres | P.O. 2188 | San Diego | CA | 92111 | 619 545-1447 | 82 |
SELECT Customer.[Cust#] AS [Customer_Cust#], Customer.CustName, Customer.Street, Customer.City, Customer.State, Customer.Zip, Invoice.[Order#] AS [Invoice_Order#], Invoice.[Cust#] AS [Invoice_Cust#], Invoice.OrderDate, Invoice.Status, InvoiceLineItem.[Order#] AS [InvoiceLineItem_Order#], InvoiceLineItem.[Line#], InvoiceLineItem.SKU, InvoiceLineItem.OrdQty, Inventory.Description, Inventory.UnitPrice, Inventory.UnitWeight
FROM (Customer INNER JOIN Invoice ON Customer.[Cust#] = Invoice.[Cust#]) INNER JOIN (Inventory INNER JOIN InvoiceLineItem ON Inventory.[SKU] = InvoiceLineItem.[SKU]) ON Invoice.[Order#] = InvoiceLineItem.[Order#];
SELECT *
FROM Invoice INNER JOIN Customer ON Invoice.CustNum = Customer.CustNum;
SELECT *
FROM Invoice
WHERE Status = 'Open'
ORDER BY CustNum;