Linking 3 tables 1

[Gatorajc]

I have 3 tables

Orders
pk OrderID
CustId


OrderItems
pk OrderItemID
fk OrderID
fk productid
qty

Products
pk ProductId
ProductDescription


I want to get this result

CustID Qty ProductDescription
Smith 4 Meter

Thanks in advance.



AJ


Do you feel lucky?

 

[PHV]

SELECT CustID,qty,ProductDescription
FROM Orders A INNER JOIN Orderitems B ON B.OrderID=A.OrderID
INNER JOIN Products C ON C.ProductId=B.ProductId

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Gatorajc]

Perfect

AJ


Do you feel lucky?