Bird
0
0

Which SQL keyword is used to combine rows from two or more tables based on a related column?

easy📝 Syntax Q3 of 15
SQL - INNER JOIN
Which SQL keyword is used to combine rows from two or more tables based on a related column?
ASELECT
BJOIN
CWHERE
DGROUP BY
Step-by-Step Solution
Solution:

  1. Step 1: Identify the keyword for combining tables

    The JOIN keyword is specifically used to combine rows from multiple tables based on related columns.

  2. Step 2: Differentiate from other keywords

    SELECT retrieves data, WHERE filters rows, and GROUP BY groups rows, but none combine tables.

  3. Final Answer:

    JOIN -> Option B

  4. Quick Check:

    Keyword for combining tables = JOIN [OK]
Quick Trick: Use JOIN to combine tables on related columns [OK]
Common Mistakes:
MISTAKES
  • Using WHERE to combine tables instead of JOIN
  • Confusing GROUP BY with JOIN

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Joins - Natural join and its risks - Quiz 10hard GROUP BY and HAVING - GROUP BY with aggregate functions - Quiz 2easy GROUP BY and HAVING - HAVING clause for filtering groups - Quiz 15hard INNER JOIN - Joining on primary key to foreign key - Quiz 11easy INNER JOIN - INNER JOIN with multiple conditions - Quiz 6medium LEFT and RIGHT JOIN - LEFT JOIN vs RIGHT JOIN decision - Quiz 1easy Set Operations - INTERSECT for common rows - Quiz 6medium Subqueries - Nested subqueries - Quiz 6medium Views - Updatable views and limitations - Quiz 2easy Views - View as a saved query mental model - Quiz 4medium