Multiple choice technology databases

The FULL JOIN keyword return rows when there is a match in one of the tables.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

FULL JOIN (or FULL OUTER JOIN) returns all rows when there is a match in either table - it returns matched rows from both tables, plus unmatched rows from each table padded with NULLs. This differs from INNER JOIN (only matches) or LEFT/RIGHT JOIN (matches plus unmatched from one side). The statement accurately describes FULL JOIN behavior of returning rows when there's a match in at least one of the tables.

Keep practicing — related questions