ai.Reserve_Price > MAX(ab.Bid_Amount)
);
This statment does seem to pull the correct data.
Original Message:
>From: "Pascal Peters" <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL Query Help (I'm stuck again)
>Date: W
that worked, thank you very much.
So far out of all the resources I have used in the past, this one is by far the best.
Original Message:
>From: "Pascal Peters" <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL Query Help (I'm stuck aga
/2003 16:43
Aan: CF-Talk
CC:
Onderwerp: RE: SQL Query Help (I'm stuck again)
If I ad the Max(ab.Bid_Amount) to the select statment and remove the HAVING
line, I do not get any errors, but I also return all records that have had
l all of the records that did not receive a bid meeting or
exceeding the reserve price.
Thanks Again
Original Message:
>From: "Michael Traher" <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL Query Help (I'm stuck again)
>Date: Wed, 10
lk
Subject: RE: SQL Query Help (I'm stuck again)
Using the following code, I get
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.
t;MAX(ab.Bid_Amount)' as part of an
aggregate function.
I think we are close, but still having problems.
Original Message:
>From: "Pascal Peters" <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL Query Help (I'm stuck again)
>
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)
-Oorspronk
7 matches
Mail list logo