Read this SQL tutorial to learn when ... used methods for consolidating data from multiple tables into a single result set: SELECT, JOIN, UNION and subqueries. SEE: Take advantage of these quick ...