90.4k views
1 vote
A LEFT JOIN is commonly used to find records in one table that do not match records in another table. A. True B.False

1 Answer

6 votes

Final answer:

A LEFT JOIN is commonly used to find records in one table that do not match records in another table.

Step-by-step explanation:

A LEFT JOIN is commonly used in database queries to retrieve records from one table that do not have a matching record in another table. It includes all the records from the left table and the matching records from the right table.

For example, let's say we have two tables: 'Students' and 'Grades'. If we want to find all the students who do not have a grade yet, we can perform a LEFT JOIN to get those records.

So, the statement 'A LEFT JOIN is commonly used to find records in one table that do not match records in another table' is true.

User Woland
by
8.5k points