Posted by Erland Sommarskog on 06/20/71 11:31

Jack Smith (jacksmith@nospam.co.uk) writes:
> Thank-you! One thing though if possible - can you repost your solution,
> but nest the brakets around the joins.

I'd rather not...

Personally, I would write Steve's solution as:

SELECT P.Name, S.StarSignName, F.FoodName
FROM PERSON P
LEFT JOIN SIGN S ON P.StarSign = S.StarSign
LEFT JOIN FOOD F ON P.FavFood = F.Food;

You can add parentheses to your heart's content, but for this query
it would add more confusion than necessary.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: QUESTION: No Support for SQL 2K on W2K3??
• Prev in forum: Re: Question about Views and sp_refreshviews
• Thread view: Re: How to do a JOIN statement for a table with 2, one-to-many relationships.

[Reply to this message]