The answer is Inner Join because it specifically focuses on returning only the rows that have matching values in both tables being joined. When an Inner Join is performed, the resulting dataset includes only those records that have corresponding entries in both tables based on the join condition. For example, if you join a table of customers with a table of orders, an Inner Join will retrieve only the customers who have placed orders, omitting those who have not.
In contrast to this, other types of joins like Full Join and Outer Join include non-matching rows along with matching ones. A Full Join combines the results of both Left and Right Joins and returns all rows from both tables, with nulls in places where there are no matches. An Outer Join, depending on whether it's left or right, will include non-matching rows from one table alongside matching rows.
Equijoin refers to a specific type of join that involves a comparison between two tables based on the equality of their defined attributes, but it is not a distinct type of join; it's typically used in the context of Inner Joins and joins based on equality conditions. Thus, while Equijoin may describe the method of specifying join conditions, it does not define the type of result set generated.