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.

Question

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.

Knowee AI · Accepted Answer

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.

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

Question

Question 20

Solution

Explanation

Similar Questions

Upgrade your grade with Knowee