Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER

The correct answer is: OUTER.

Explanation

• INNER JOIN returns only the rows with matching values in both tables.
• LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table and the matched rows from the right table; if there is no match, NULLs are returned for columns from the right table.
• RIGHT JOIN (or RIGHT OUTER JOIN) returns all rows from the right table and the matched rows from the left table; if there is no match, NULLs are returned for columns from the left table.
• OUTER JOIN refers to the combination of both LEFT and RIGHT JOINS, hence it returns all matching records as well as unmatched records from both tables.

Thus, OUTER JOIN is the correct choice as it encompasses both sides of the join operation.