Multiple choice technology databases

What type of join is needed when you wish to include rows that do not have matching values?

  1. Equi-join

  2. Natural join

  3. Outer join

  4. All of the above.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Outer joins are specifically designed to include rows that don't have matching values in the joined table. This includes LEFT JOIN (all from left table), RIGHT JOIN (all from right table), and FULL JOIN (all from both). Inner joins and equi-joins only return matching rows.