A left outer join on tables CUSTOMER and AGENT yields all of the rows in the CUSTOMER table,including those that do not have a matching value in the AGENT table.

Question

Quizplus · Accepted Answer

This is the correct definition of a left outer join. It includes all the rows from the left table, in this case, CUSTOMER, and only matching rows from the right table, in this case, AGENT. The non-matching rows from the right table are replaced with NULL values.

A Left Outer Join on Tables CUSTOMER and AGENT Yields