ASP.NET Web Programming Homework Computer Science

Orders379.accdb

Home >Computer Science homework help > ASP.NET Web Programming Homework Computer Science

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;