At 20:21 +0100 12/17/02, Csongor Fagyal wrote:
Hi,
I have two tables: one holding bids for an auction (table bids) and
one holding user data who placed the bids (users). I would like to
get the highest bid, the user who placed the bid and the number of
bids placed, so I use the following
I have two tables: one holding bids for an auction (table bids) and
one holding user data who placed the bids (users). I would like to get
the highest bid, the user who placed the bid and the number of bids
placed, so I use the following query:
SELECT MAX(bids.amount) AS amount,
Hi,
I have two tables: one holding bids for an auction (table bids) and one
holding user data who placed the bids (users). I would like to get the
highest bid, the user who placed the bid and the number of bids placed,
so I use the following query:
SELECT MAX(bids.amount) AS amount,