Marisa Fox
CSIS 325
Homework Due: 3/29/2016
Chapter 4: 11, 12, 14, & 17
11.
Access:
SELECT OrdNum OrdDate, Customer.CustNo, CustFirstName, CustLastName
FROM OrderTbl, Customer
WHERE OrdState = ‘CO’ AND OrdDate BETWEEN ‘1-Jan-2013’ AND ’31-Jan-2013’
AND OrderTbl CustNo = Customer.CustNo
Or
Oracle:
SELECT OrdNum OrdDate, Customer.CustNo, CustFirstName, CustLastName
FROM OrderTbl, Customer
WHERE OrderTbl.CustoNo = Customer
Or
Access with INNER JOIN:
SELECT OrdNum OrdDate, Customer.CustNo, CustFirstName, CustLastName
FROM OrderTbl INNER JOIN Customer ON OrderTbl.CustNo = Customer.CustNo
WHERE OrdState = ‘CO’ AND OrdDate BETWEEN #1/1/2013# AND #1/31/2013#
12.
Access:
SELECT OrdNum OrdDate, Customer.CustNo, CustFirstName, CustLastName
FROM OrderTbl, Customer
WHERE OrdState = ‘WA’ AND OrdDate BETWEEN #1/1/2013# AND #1/31/2013#
AND OrderTbl CustNo = Customer.CustNo AND CustState = ‘CO’
14.
Access:
SELECT OrdNum OrdDate, Customer.CustNo, CustFirstName, CustLastName, Employee.EmpNo,
EmpFirstName, EmpLastName
FROM OrderTbll Customer, Employee
WHERE OrdState = ‘CO’ AND OrdDate BETWEEN #1/1/2013# AND #1/31/2013#
AND OrderTbl CustNo – Customer.CustNo
AND OrderTbl EmoNo= Employee.EmpNo
17.
Access:
SELECT Customer.CustNo, CustFirstName, CustLastName, OrderTbl.OrdNo, OrdDate,
Employee.EmpNo, EmpFirstName, EmpLastName, Product.ProdNo, ProdName, ProdPrice*Qty AD
OrderCost
FROM OrderTbl, OrdLine, Product, Customer, Employee
WHERE OrdDate = #1/23/2013# AND ProdPrice*Qty > 150
AND OrderTbl.OrdNo = OrdLine.OrdNo
AND OrdLine.ProdNo = Product.ProdNo
AND OrderTbl.CustNo = Customer.CustNo
AND Employee.EmpNo = OrderTbl.EmpNo
Powered by TCPDF (www.tcpdf.org)
