Thanks for the further input, It works perfectly ...
If you wouldn't mind please explain, the use of the b1 and b2 are they
intended as varaibles ..
On 3/17/06, Michael Stassen [EMAIL PROTECTED] wrote:
Gregory Machin wrote:
Ok I tried the following
SELECT dealer_id, auto_id, bid_amount
Ok I tried the following
SELECT dealer_id, auto_id, bid_amount FROM bids WHERE bid_amount=(SELECT
MAX(bid_amount) FROM bids WHERE auto_dealer_id='3');
which gives
+---+-++
| dealer_id | auto_id | bid_amount |
+---+-++
| 3 | 12 |
Gregory Machin wrote:
Ok I tried the following
SELECT dealer_id, auto_id, bid_amount FROM bids WHERE bid_amount=(SELECT
MAX(bid_amount) FROM bids WHERE auto_dealer_id='3');
which gives
+---+-++
| dealer_id | auto_id | bid_amount |
+---+-++
Hi.
I have the following table
| bid_id | dealer_id | auto_dealer_id | auto_id | bid_amount | timestamp |
Bid_Status |
+-+-+--++-++-+
| 1 |3 | 3 |12 |
Gregory Machin wrote:
Hi.
I have the following table
| bid_id | dealer_id | auto_dealer_id | auto_id | bid_amount | timestamp |
Bid_Status |
+-+-+--++-++-+
| 1 |3 |