Multiple choice technology databases

Which Joins allows to bring non matching data in TSQL

  1. (a) Full outer join

  2. (b) Inner join

  3. (c) Right outer join

  4. (d) Left outer join
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Outer joins (left, right, and full) are designed to retrieve non-matching rows from one or both tables, filling missing columns with NULLs. An inner join only returns rows where there is a match in both tables.

Keep practicing — related questions