Which type of JOIN operation retrieves record data with a join column value present only in the first table of the join and the results of the inner join?
A) Inner join
B) Left outer join
C) Right outer join
D) Full outer join

Question

Quizplus · Accepted Answer

A Left outer join retrieves all records from the first (left) table and the matched records from the right table. If there is no match, the result is NULL on the side of the right table. This includes the results of an inner join plus all the records in the first table that do not match any record in the second table.

Which Type of JOIN Operation Retrieves Record Data with a Join