Which JOIN returns only the matching rows from both tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

Breakdown the Problem

1. We need to identify the type of SQL JOIN that returns only the matching rows from both tables.

Relevant Concepts

1. INNER JOIN: Returns records that have matching values in both tables.
2. LEFT JOIN: Returns all records from the left table and the matched records from the right table; unmatched records from the right table will show as NULL.
3. RIGHT JOIN: The opposite of LEFT JOIN; it returns all records from the right table and matched records from the left table, with unmatched records showing as NULL.
4. FULL OUTER JOIN: Returns all records when there is a match in either left or right table records; unmatched records from both sides will show NULL.

Analysis and Detail

1. Only the INNER JOIN will return rows that exist in both tables based on the given condition. Other joins may return additional rows including those without matches.

Verify and Summarize

1. By considering the definitions of each JOIN, it's clear that the INNER JOIN is the only type that excludes non-matching rows entirely.

Final Answer

INNER JOIN is the correct answer, as it returns only the matching rows from both tables.