Which join types return all rows from only one of the tables being joined? Select all that apply.1 pointFULL OUTER JOINRIGHT JOININNER JOINLEFT JOIN

The join types that return all rows from only one of the tables being joined are:

1. RIGHT JOIN
2. LEFT JOIN

Here's why:

• RIGHT JOIN: This type of join returns all the rows from the right table and the matched rows from the left table. If no match is found, the result is NULL on the left side.

• LEFT JOIN: This type of join returns all the rows from the left table and the matched rows from the right table. If no match is found, the result is NULL on the right side.

On the other hand:

• FULL OUTER JOIN: This type of join returns all rows from both tables, matched or not. If there is no match, the result is NULL on either side.

• INNER JOIN: This type of join only returns rows when there is a match in both tables.