Posted by Jens on 04/25/06 14:21

Hi,

try this one here:


Select Cust.name,b.author,Cat.catname,oi.item_price,b.description
>From Customers Cust
INNER JOIN Orders O
ON O.CUstomerId = Cust.CustomerId
INNER JOIN Order_Items oi
ON oi.OrderId = O.OrderId
INNER JOIN books b
ON b.Isbn = oi.Isbn
INNER JOIN Categories Cat
ON c.Catid = B.catid

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Prev in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Thread view: Re: query hheeelp

[Reply to this message]