Example code for an outer join for Oracle?

From: Mark Cain <mark_at_alimar.demon.co.ukNOSPAM>
Date: 1997/10/18
Message-ID: <3448d967.3775955@news.demon.co.uk>#1/1

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 Sat Oct 18 1997 - 00:00:00 CDT