MySQL Forums
Forum List  »  Newbie

Re: Query with multiple joins
Posted by: Peter Brawley
Date: December 17, 2021 09:29PM

Homework? Mightn't getting someone else to do it for you defeat its purpose, mightn't you learn a thing or two thinking about it over a weekend?

You do need a starting method. If your instructor hasn't suggested such, here's one ... map elements from the query requirement to the tables containing columns corresponding to those elements, translate that into sql that joins those tables ....

select ...
from users
join purchase_orders on ...
join order_items on ...
where ...

... then fill in the elided column names & where conditions if any.

If you get stuck, please post what you have so far, and describe what's you're stuck on.

Options: ReplyQuote

Written By
December 17, 2021 08:10PM
Re: Query with multiple joins
December 17, 2021 09:29PM
December 19, 2021 04:19PM
December 19, 2021 08:27PM
December 21, 2021 11:56AM
December 21, 2021 02:29PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.