Which of the following join types select all the records from one table even if the related table does not have matching records? Select all the options that apply.
A) self
B) left outer
C) inner
D) right outer

Question

Quizplus · Accepted Answer

Left outer join and right outer join select all the records from one table even if the related table does not have matching records. Self join and inner join do not select all records from one table if related tables do not have matching records.

Which of the Following Join Types Select All the Records