When using a(n) _____ join, only rows from the tables that match on a common value are returned.
A) full
B) outer
C) inner
D) set

Name: When using a(n) _____ join, only rows from the tables that match on a common value are returned. A) full B) outer C) inner D) set
Brand: Quizplus
Rating: 4.7 (36 reviews)

Question

Quizplus · Accepted Answer

Inner join returns only the matching rows from the tables based on a common value. Full and outer joins return all the rows from both tables, and set join is not a valid option as it is not a type of join.

When Using A(n) _____ Join, Only Rows from the Tables