Re: Select over multiple Tables
The concept you're looking for is JOIN. Work through a sql tutorial or two on the subject, do the same with the intro chapters in the MySQL manual.
Then you'll be writing a join between your two tables. If you need further help at that point, post the query so far along with the result of Show Create Table for each table.
Subject
Written By
Posted
Re: Select over multiple Tables
October 31, 2017 09:58AM
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.