Read this SQL tutorial to learn when to use SELECT ... The result is a temporary table that contains values from two tables, where the record satisfies the WHERE expression.