Which join type selects only matching left and right table rows?

The correct answer is the Inner Join because this type of join retrieves only the rows that have matching values in both the left and right tables based on a specific condition. When you perform an Inner Join, any rows from either table that do not meet the join condition will be excluded from the result set. This makes it particularly useful for queries where only related data from both tables is required.

For instance, if you are combining data from a table of customers and a table of orders, an Inner Join would return only the customers who have made orders, effectively filtering out customers without any associated orders. This leaves you with a result set that focuses solely on the intersection of the two tables.

Other join types, like Full Join, Left Join, and Right Join, include non-matching rows in their results, which distinguishes them from the Inner Join. Full Join brings together all rows from both tables regardless of matches, while Left Join retrieves all rows from the left table and any matches from the right table (with nulls for non-matching rows), and Right Join does the opposite.