Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Super Newbie Question
Hey,
I think you would do it this way:
select a,b
from table1 a,
table2 b
where a.id = b.id(+)
This will give you all rows from a, even ones where there is no corresponding row in b Hope that helps..
defaultuser_at_domain.com wrote in article
<34154FE4.AD16B0F6_at_msg.pacbell.com>...
> Hi. I am extremely new to Oracle and have, what I hope, is a very
> elementary question for this group:
> what is the general syntax for outer joins in Oracle?
>
> In other environments I would write something like:
> "select a.*, b.* from a left outer join b on a.id = b.id"
> but this does not seem to work for Oracle.
>
> Any advice would be greatly appreciated.
>
> Len Wolfenstein
> Pacific Bell Operations Research
>
>
>
>
Received on Tue Sep 09 1997 - 00:00:00 CDT