PROBLEM SOLVED The code supplied... SELECT ai.Product_ID, ai.Status, ai.reserve_price, ai.date_enddate, MAX(DISTINCT ab.Bid_Amount) AS HighBid 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, ai.reserve_price, ai.date_enddate
Still had the same error (MISSING OPERATOR), but by removing "DISTINCT" it worked correctly. Thank You very much for all of your help. -----Original Message----- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 3:01 AM To: CF-Talk Subject: CF-Talk: Digest every hour CF-Talk 28-Aug-03 Issue:6111 In this issue: SQL Query Aggregate function problem wile trying to pull data from two tables. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
