Re: limiting rows returned

[Pavel Leonov]

Thank you for your note. Yes, that's my mistake.

I just took the result set provided by Jim without thinking that it's an ordered one.

I guess the solution is something like that:

select c.*, d.username as bidder
from
(
select max(bid_number) as bid_number, bid_auction_number
from phpbb_auction_bids
group by bid_auction_number
) as a left outer join phpbb_auction_bids as c
on a.bid_number=c.bid_number and a.bid_auction_number=c.bid_auction_number,
phpbb_users d
where c.bid_user_id = d.user_id
order by c.bid_auction_number, c.bid_number desc ;

Best regards.