Posted by Ed Murphy on 09/13/07 02:44

tescodiscolondon@googlemail.com wrote:

> Ah yes, never put your criteria into a WHERE clause.
>
> SELECT Fruit.fruitID, Fruit.fruitName, IsNull(buyerID, 0)
> FROM Fruit INNER JOIN Basket ON Fruit.fruitID = Basket.fruitID AND
^^^^^ OUTER, surely?
> Basket.buyerID = 12
>
> gives me what I wanted.

• Next in forum: Re: One bound form does NOT save record - please help!
• Prev in forum: Re: Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables
• Thread view: Re: simple OUTER JOIN (I thought)

[Reply to this message]