Sunday, June 16, 2019

Database management Coursework Example | Topics and Well Written Essays - 1750 words

Database management - Coursework Example have distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between 01-Feb-2007 and 28-Feb-2007)select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between 02/01/2007 and 02/28/2007)select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and month(OrderTbl.OrdDate)=2 and year(OrderTbl.OrdDate)=2007select distinct Product.ProdNo, Product.ProdName, Product.ProdPrice from Product, OrdLine, OrderTbl where Product.ProdNo = OrdLine.ProdNo and OrdLine.OrdNo = OrderTbl.OrdNo and OrderTbl.CustNo = C0954327 and (OrderTbl.OrdDate between 01-Jan-2007 and 31-Jan-2007)select distinct Product.ProdNo, Product .ProdName, Product.ProdPrice from Product, OrdLine, OrderTbl where Product.ProdNo = OrdLine.ProdNo and OrdLine.OrdNo = OrderTbl.OrdNo and OrderTbl.CustNo = C0954327 and (OrderTbl.OrdDate between

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.