DatabaseHW2

DatabaseHW2 - 6. SELECT Rep WHERE RepNumber=20 GIVING Temp...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Intro to databases HW Solution Assignment.2 2. SELECT Part WHERE PartNum = FD21 GIVING Answer 4. SELECT Rep WHERE LastName=Kaiser GIVING Temp JOIN Customer Temp WHERE Rep.RepNum=Customer.RepNum GIVING Temp2 PROJECT Temp2 OVER (OrderNum, OrderDate, CustomerNum, CustomerName, LastName)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6. SELECT Rep WHERE RepNumber=20 GIVING Temp JOIN Customer Temp WHERE RepNumber=20 GIVING Temp1 SELECT Orders WHERE OrderDate=10/20/2007 GIVING Temp2 JOIN Temp1 Temp2 WHERE Temp1.CustomerNum=Temp2.Customer2 GIVING Temp3 PROJECT Temp3 OVER (OrderNum, OrderDate)...
View Full Document

Ask a homework question - tutors are online