When you code an outer join, you include the LEFT or RIGHT keyword to specify the type of outer join you want to perform. An outer join retrieves all rows that …

source