projection from a query

[pritesh kumar]

i am trying to write a query that would do the following on the view update_winnerlist which is already GROUPed BY item_index

SELECT email_id
(SELECT email_id,min(bid_amount)
FROM update_winnerslist AS a1
WHERE a1.item_index = 10 )

i need to perform the above in a single query as i am using it in a trigger to update a table.
PLZ HELP



Edited 1 time(s). Last edit at 04/25/2012 07:25PM by pritesh kumar.