Multiple choice technology databases

An outer join is used to:

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

An outer join retrieves all rows that satisfy the join condition plus those rows from one or both tables that do not have a matching row in the other table. Inner joins only return records with a direct match, while outer joins are specifically used to preserve unmatched records that would otherwise be excluded.

Keep practicing — related questions