PHWinfo - Afficher un message

13/09/2007, 04h44

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.

13/09/2007, 04h44	#3
Ed Murphy Messages: n/a Hébergeur:	Re: simple OUTER JOIN (I thought) 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.