Multiple choice technology programming languages

Which of the following WHERE clauses represent equi-join?

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An equi-join requires equality between columns with the same name from both tables. Option B shows Table1.column1 = Table2.column1, which matches identical column names. Options A and C join different columns (column1 to column2), which would be a non-equi-join unless explicitly aliased.

Keep practicing — related questions