sprkd
.io
🗡️ Gauntlet
Courses
Roles
Certs
Coach
Pricing
Sign in
🗄️
Databases
1 / 12
SQL & Queries
Working
Placing a condition in the ON clause of a LEFT JOIN versus the WHERE clause matters because:
A
WHERE conditions cannot reference joined columns
B
ON and WHERE are always interchangeable for outer joins
C
A condition on the right table in WHERE can turn a LEFT JOIN into an effective INNER JOIN by discarding NULL-extended rows
D
ON conditions run after WHERE conditions
← Back
Next →
