Left Outer Join Examples

Example 1

Select c.customer_id, c.name,
           cd.email, cd.phone
  From customers c
           LEFT OUTER JOIN customers_details cd
           ON cd.customer_id = c.customer_id
Where c.customer_id > 3500
Order By c.customer_id

Example 2

Select c.customer_id, c.name, cd.email, cd.phone
  From customers c,
           customers_details cd
Where cd.customer_id (+) = c.customer_id
Order By c.customer_id