Which of the following returns all the records from the table on the left side of the join and only the records that have a matching value from the table on the right side of the join?
A) join type property
B) inner join
C) left outer join
D) right outer join

Question

Quizplus · Accepted Answer

The left outer join returns all records from the 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.

Which of the Following Returns All the Records from the Table