Re: Left and Right Joins

Suppose your table Addresses has a person's name as the primary key, but might not have an address for each person.

Left join:

    select a.name, b.address
    from persons a
    , addresses b
    where b.name (+) = a.name;

Right join:

    where a.name = b.name (+);

Innerjoin:

    where a.name = b.name;

Arjan. Received on Mon Sep 07 1998 - 11:56:24 CDT