All pastes #433336 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-04-10 18:57 UTC
rendered paste body
SELECT *
FROM [Item], [Category], [Bid]
WHERE [Item].[item_id] = [Bid].[item_id]
AND [Item].[category_id] = [Category].[category_id]
AND [Bid].[bidder_id] = ?



// I have three tables I need to draw data from : Item, Category and Bid
// I need to obtain one row for each item - right now, I'm getting multiple
// rows for each item, depending on how many bids are on each item.