Multiple choice technology databases

Which operators can be used in an outer join condition?

  1. =

  2. OR

  3. IN

  4. AND

Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

Outer join conditions traditionally use the = operator for the join itself between tables. The AND operator can add additional filter conditions to the join. The OR and IN operators cannot be used in the ON clause of traditional SQL outer joins.