Question

Amed is utilizing a feature that will use two tables. The first table contains a primary key matched to a foreign key in the second table. The query results will include all entries from the first table. Which feature is he using?

left outer join
right outer join
self join
inner join

Answer 1

left outer join

A LEFT OUTER JOIN returns all rows from the left (first) table and the matching rows from the right (second) table (NULLs where there's no match).