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

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