All pastes #441048 Raw Edit

Anonymous

public sql v1 · immutable
·published 2007-04-15 13:37 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] = ?AND [Bid].[bid_id] = (SELECT TOP 1 [QB].[bid_id] FROM [Bid] AS [QB]WHERE [QB].[item_id] = [Item].[item_id] AND [QB].[bidder_id] = ?ORDER BY [QB].[bid_id] DESC)