A

Admin • 833.24K Points
Coach

Q. Which JOIN returns only rows that exist in both joined tables?

  • (A) LEFT JOIN
  • (B) RIGHT JOIN
  • (C) INNER JOIN
  • (D) FULL OUTER JOIN
  • Correct Answer - Option(C)
  • Views: 54
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

INNER JOIN returns rows common to both tables. LEFT JOIN returns all rows from the left table and matched rows from the right; RIGHT JOIN returns all from the right; MySQL does not natively support FULL OUTER JOIN (requires workarounds).

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.