this should work
SELECT ai.Product_ID, ai.Status
FROM Auction_Items ai, Auction_Bids ab
WHERE ai.Status = 'ACTIVE'
AND ai.date_EndDate < #createODBCDate(now())#
AND ai.Product_ID = ab.Product_ID
GROUP BY ai.Product_ID, ai.Status
HAVING ai.Reserve_Price > MAX(ab.Bid_Amount)
-----Oorspronkelijk bericht-----
Van: Michael C.Grove [mailto:[EMAIL PROTECTED]
Verzonden: wo 10/09/2003 7:26
Aan: CF-Talk
CC:
Onderwerp: SQL Query Help (I'm stuck again)
SAMPLE 2
UPDATE Auction_Items
SET Status = 'CLOSED'
WHERE EXISTS (SELECT ai.Product_ID, ai.Status
FROM Auction_Items ai, Auction_Bids ab
WHERE ai.Status = 'ACTIVE'
AND ai.date_EndDate < #createODBCDate(now())#
AND ai.Product_ID = ab.Product_ID
AND ai.Reserve_Price > ab.Bid_Amount
GROUP BY ai.Product_ID, ai.Status);
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
