Re: Can I have left join or right join in Oracle?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 22 Aug 2000 11:48:06 +0100
Message-ID: <8ntlpc$10s$1@soap.pipex.net>

look into outer join. Should be in the SQL reference. the sql you will generate will look like

select a.col1,b.col2
from a,b
where
a.col3 =b.col4 (+)

etc.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Carfield Yim" <carfield_at_programmer.net> wrote in message
news:39A0BBC9.44E37185_at_programmer.net...


> How, I can't find left join or right join in oracle document...

>

> Ulrik Hoffmann wrote:

>

> > carfield_at_programmer.net (Carfield Yim) wrote in

> > <399FE394.EF81A05B_at_programmer.net>:

> >

> > >Can I have left join or right join in Oracle?

> >

> > YES.

>

Received on Tue Aug 22 2000 - 05:48:06 CDT