Multiple choice technology databases

We refer to a join as a self-join when…

  1. we are using left and right join together

  2. we are joining more than 2 tables

  3. we are joining table to itself

  4. when joining a table and its view

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

A self-join occurs when a table is joined to itself, typically to compare rows within the same table. This is done by using table aliases to treat the same table as two different tables in the join.