194k views
5 votes
Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins. True or False?

User Lykos
by
7.7k points

1 Answer

2 votes

Final answer:

The statement that outer joins include matching rows from joined tables plus unmatched rows from one other table is true. Outer joins can be left, right, or full, each including unmatched rows in a distinct way.

Step-by-step explanation:

The statement is true. Outer joins are a type of join in SQL that are used to combine rows from two or more tables. Unlike inner joins, which only return matching rows from the joined tables, outer joins include all rows from one table and the matched rows from the other. There are three types of outer joins: left outer join, right outer join, and full outer join.

A left outer join returns all rows from the left table and the matched rows from the right table; if there is no match, NULL values are returned for the right table. Similarly, a right outer join includes all rows from the right table and the matched rows from the left table, with NULLs for unmatched rows from the left table. Lastly, a full outer join returns all rows when there is a match in either left or right tables and NULLs for rows with no match in the other table.

User John Eikenberry
by
7.9k points