Posted by Bandul on 04/26/06 12:37

Thanks Jens
"Jens" <Jens@sqlserver2005.de> wrote in message
news:1145964090.342085.171400@y43g2000cwc.googlegroups.com...
> 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: Compound Primary Key - order not as expected
• Prev in forum: Log Shipping to two Databases on One Secondary Server
• Thread view: Re: query hheeelp

[Reply to this message]