Computer Science AQA A level: SQL
How would you compare and return matching data from more than one table

Question

SQL
How would you compare and return matching data from more than one table

Will Parker · Accepted Answer

SELECT Table1.ColumnX, Table2.ColumnY, Table2.ColumnX, ...
FROM Table1, Table2, ...
WHERE Table1.ColumnZ = Table2.ColumnZ

The selct is whats going to be printed as a new table
The from is just every table you want to use
The where is the condtion on whats selected

SQL How would you compare and return matching data from more than one table