Write a query using JOINS to list the orderid, partid, and part description and

Question

Write a query using JOINS to list the orderid, partid, and part description and units on hand or every order that has not shipped.

SalesRep Customer PK ReplD int varchar(20) varchar(20) PK CustomerlD int O--OLastName FirstName CommissionRate decimal(10,2) LastName varchar(20) FirstName varchar(20) Street City State Zipcode char(5) Balance decimal( 10,2) varchar(20) varchar(20) char(2) Order FK1 ReplD int FK1 CustomerlD int OrderDat date ShipDate date Part PK PartID int OrderLine Description varchar(20) UnitsOnHand int ItemClass char(4) Retail Cost PK,FK1 OrderlD int decimal (10,2) decimal (10,2) Quantityint

Explanation / Answer

SELECT Order.OrderID, Part.PartID, Part.Description, Part.UnitsOnHand
FROM (OrderLine
INNER JOIN Order ON Order.OrderID = OrderLine.Order.ID)
INNER JOIN Part ON Part.PartID = OrderLine.PartID);

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---