I'm trying to join 3 tables
users. I need several key pieces of information from each table based on the
offers table. In the end I want a general summary of the auctions. To see the latest offer for each auction and the user who placed it.
I'm used to doing simple SQL queries and I'm not sure what I should do to achieve this. Not looking for a solution (although I would take it with an explanation) but learning experience.
Consult so far
So far, this is what I have started with, any guidance on what to do from here is very much appreciated.
SELECT MAX (bids.id) AS & # 39; Offer ID & # 39 ;, bids.auction_id AS & # 39; auction ID & # 39 ;, auctions.title AS & # 39; Title of the auction & # 39 ;, MAX (bids.bid_amount) LIKE & # 39; Offer amount & # 39; SINCE boardman_bidding.bids UNIT INTERNALLY boardman_bidding.auctions ON bids.auction_id = uctions.id UNIT INTERNALLY boardman_bidding.users ON bids.user_id = users.id WHERE bids.auction_id> 1065 AND uctions.city_id = & # 39; 45621 & # 39; GROUP BY bids.auction_id ORDER BY ofertas.auction_id DESC;