|
|
Posted by tescodiscolondon on 09/11/07 14:38
Two tables:
Fruit
fruitID, fruitName
Basket
buyerID, fruitID
(ie. we can see which buyer has what fruit in their basket)
I simply want to display all available fruit and whether or not it's
in a specific persons' basket.
SELECT Fruit.fruitID, Fruit.fruitName, IsNull(buyerID, 0)
FROM Fruit INNER JOIN Basket ON Fruit.fruitID = Basket.fruitID
WHERE Basket.buyerID = 12
but this just gives me what's in buyer 12s' basket.
What am I doing wrong? Am I a basket case...
Navigation:
[Reply to this message]
|