Which type of join,although not included in standard SQL,was created to allow unmatched rows to appear in the result of a join operation?
A) ODD JOIN
B) OPEN JOIN
C) OUTER JOIN
D) INNER JOIN
E) COMBINE JOIN

Question

Quizplus · Accepted Answer

An outer join allows unmatched rows from one or both tables to appear in the result of a join operation. The options A, B, D, and E are not valid types of joins in SQL.

Which Type of Join,although Not Included in Standard SQL,was Created