Intermediate
SQL
Q62 / 100
What is the difference between "WHERE" and "ON" clauses when used with JOINs?
Correct! Well done.
Incorrect.
The correct answer is B) ON specifies the join condition that determines how rows from the two tables are matched, while WHERE filters the joined result afterward — this distinction matters especially for OUTER JOINs
B
Correct Answer
ON specifies the join condition that determines how rows from the two tables are matched, while WHERE filters the joined result afterward — this distinction matters especially for OUTER JOINs
Explanation
For OUTER JOINs, placing a condition in ON affects which rows are matched (and thus which produce NULLs), while the same condition in WHERE filters out rows after the join, potentially changing results.
Progress
62/100