Which join type selects all rows from both tables as long as there is a match between the columns in both tables?

Which join type selects all rows from both tables as long as there is a match between the columns in both tables?

• A. Cross Joins
• B. Full joins
• C. Inner Join
• D. Left (or Right) Join

Answer: (C)

Inner joins bring together rows from two tables only where the specified columns match. It returns the set of rows that have a matching value in both tables, combining the related data from each side. That matches the idea of “select all rows from both tables as long as there is a match between the columns in both tables.” A cross join would pair every row with every row, producing a result with all possible combinations, not just matches. A full join would include non-matching rows from either side, filling with NULLs where there is no match. A left or right join would retain all rows from one side and bring in matching rows from the other, with NULLs for non-matches. So the inner join is the one that aligns with the described behavior.

Inner joins bring together rows from two tables only where the specified columns match. It returns the set of rows that have a matching value in both tables, combining the related data from each side. That matches the idea of “select all rows from both tables as long as there is a match between the columns in both tables.”

A cross join would pair every row with every row, producing a result with all possible combinations, not just matches. A full join would include non-matching rows from either side, filling with NULLs where there is no match. A left or right join would retain all rows from one side and bring in matching rows from the other, with NULLs for non-matches. So the inner join is the one that aligns with the described behavior.