Multiple choice technology databases

To write a query that performs an outer join of tables A and B and returns all rows from B, you need a:

  1. left outer join

  2. inner join

  3. equil join

  4. right outer join
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A RIGHT OUTER JOIN returns all rows from the right table (B), plus matched rows from table A. Unmatched rows from A show NULL. LEFT OUTER JOIN would return all rows from A instead.

Keep practicing — related questions