Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Database systems1

af
af 


this is a class for database systems. I need help with getting this assignment done quickly. This assignment also deals with SQL server. Attachments Tags
Clarifications

Answers

Assignment 4 Solution SQL

mariobeka
mariobeka 



Below the solution queries for Assignment 4. Attachments
CS400 Assg4.txt (1 K) Download Preview
o, "Order Details" od WHERE p.ProductID = od.ProductID AND od.OrderID = o.OrderID AND s.ShipperID = o.ShipVia AND o.ShipCity = "Portland" AND o.ShippedDate = [Enter correct date] ORDER BY p.ProductName; 5. SELECT ca.CategoryID, ca.CategoryName, p.ProductID, p.ProductName, p.UnitsInStock, p.UnitsOnOrder, c.ContactName FROM Products p, Customers c, Orders o, "Order Details" od, Categories ca WHERE p.ProductID = od.ProductID AND od.OrderID =

Screenshots
Purchase Answer