A(n)____ join combines rows from both tables using matching column names and column values.
A) outer
B) inner
C) cross
D) self

Question

Quizplus · Accepted Answer

An inner join combines rows from both tables that have matching column values in the specified column(s). This type of join only returns the rows that have matching values, therefore it's the most appropriate choice. Outer joins return all the rows from one or both tables, even if there are no matching values, while cross join combines every row from one table with every row from the other table. Self join combines rows from a single table based on matching column values, which is not what we are looking for in this scenario.

A(n)____ Join Combines Rows from Both Tables Using Matching Column