mysql – Joining 3 tables while using MAX

I'm trying to join 3 tables auction, offersY 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.

auctions

I.D, Title, Location

offers

I.D, Auction_id, user_id, bid_amount

users

I.D, first name, address

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;