A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.
A) outer
B) inner
C) equi-
D) cross

Question

Quizplus · Accepted Answer

An outer join returns not only the rows matching the join condition but also the rows with unmatched values. Inner join returns only the rows that have matching values in both tables. Equi-join is a type of join where the joining condition is based on equality between two columns from different tables. Cross join returns the Cartesian product of the two tables, which means that it returns all possible combinations of rows from both tables.

A(n) _____ Join Returns Not Only the Rows Matching the Join