All pastes #433320 Raw Edit

Someone

public javascript v1 · immutable
·published 2007-04-10 18:49 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.