Hello

Using an auction example, how do you implement this in one query.

For example you have items table and bid table. Now an item can have more than one bid. Suppose I would like only to get the value of the highest bid imported to Items class so can do something like this in my DAO object:

...
Object[] obj = (Object[])iter.next()
Items item = (Items)obj[0];
Bid bid = item.getBid();

How do you implement Max???

Thanks

oh by the way i am using MYSQL.

I have tried using max(bidAmount) as in SELECT max(bid) from BID in SQL but did not work.