Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple ... tables are involved. There are several types of JOIN — LEFT, RIGHT, and FULL OUTER; INNER ...