Question

If you want to create a query that shows records from one table that have no corresponding records in another table, use a ____________.

1) JOIN
2) UNION
3) LEFT JOIN
4) RIGHT JOIN

Answer 1

To show records from one table that have no corresponding records in another table, use a LEFT JOIN statement.

Step-by-step explanation:

If you want to create a query that shows records from one table that have no corresponding records in another table, you would use a LEFT JOIN statement. The LEFT JOIN retrieves all the records from the left table (the one specified before the JOIN keyword) and the matching records in the right table (specified after the JOIN keyword). Any records that do not have a match in the right table will have NULL values for the right table columns.