Re: Example code for an outer join for Oracle?

Mark Cain wrote:
>
> 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 where table1.id = table2.id (+)
 where table2 doesn't include all id-value from tabel1
>
> Thanks in anticipation
> ---------------------------------------------------
> | Mark Cain mark_at_alimar.demon.co.uk (remove NOPSAM)
> | www.alimar.demon.co.uk
> ---------------------------------------------------
 

-- 
Regards

M.Gresz    :-)