Multiple choice technology databases

Which of the following SQL clauses is used to select data from 2 or more tables?

  1. HAVING

  2. JOIN

  3. WHERE

  4. BETWEEN
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

JOIN clauses combine rows from two or more tables based on related columns. HAVING filters grouped results, WHERE filters individual rows, and BETWEEN specifies a range value - none of these combine data from multiple tables.

Keep practicing — related questions