Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which JOIN returns all rows from the left table and matching rows from the right, with NULLs where there is no match?

  1. A INNER JOIN
  2. B LEFT JOIN
  3. C RIGHT JOIN
  4. D CROSS JOIN
Answer

LEFT JOIN

A LEFT JOIN preserves every row from the left table. Putting a condition on the right table in WHERE rather than ON silently converts it to an INNER JOIN.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as