MySQL Forums
Forum List  »  Newbie

Re: Return sales orders if certain item was purchased
Posted by: Tim Bond
Date: July 06, 2017 02:24PM

I am not building a database, I am writing a query to extract information from a table that brings together multiple different sources together.

Each SON can have multiple PNs and each PN can exist in multiple SONs, meanings it is a many:many, but that is besides the point.

I believe I will need to use an inner query, but I cannot figure out the syntax.

Any help would be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Re: Return sales orders if certain item was purchased
July 06, 2017 02:24PM


Sorry, you can't reply to this topic. It has been closed.

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.