Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

What happens when a LEFT JOIN has a condition on the right table in the WHERE clause?

A It effectively becomes an INNER JOIN by discarding the NULL rows
B It returns more rows
C It errors
D Nothing changes

Answer

It effectively becomes an INNER JOIN by discarding the NULL rows

Putting the condition in the ON clause instead preserves the unmatched left rows, which was the point of the LEFT JOIN.

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer