Re: Example code for an outer join for Oracle?

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 1997/10/19
Message-ID: <01bcdc8f$123f3ea0$5e82f1c3@worldonline>#1/1

Hey Mark,

How about:

select table1.fielda, table2.fieldb
from table1

       ,table2
where table1.id = table2.id(+)

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl http://home.worldonline.nl/~bytelife check out : http://home.worldonline.nl/~bytelife/storage.htm

Mark Cain <mark_at_alimar.demon.co.ukNOSPAM> schreef in artikel <3448d967.3775955_at_news.demon.co.uk>...
> Can anyone give me a simple example of an outer right join, using 2
 tables?
>
> I'm trying something like:
>
> select table1.fielda, table2.fieldb from table1 outer join table2 on
 table1.id = table2.id
>
>
> Thanks in anticipation
> ---------------------------------------------------
> | Mark Cain mark_at_alimar.demon.co.uk (remove NOPSAM)
> | www.alimar.demon.co.uk
> ---------------------------------------------------
>
Received on Sun Oct 19 1997 - 00:00:00 CDT