Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple ... table, table1, contains the data being returned, while the other, table2, provides a ...