Oracle Tutorial

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