Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with ... will return all relevant rows from the first table listed, while potentially ...