select a.emp,
b.ValueA
c.ValueB
>From base_table A
RIGHT OUTER JOIN child_Table1 B ON b.emp = a.emp
RIGHT OUTER JOIN child_Table2 C ON c.emp = a.emp
-----Original Message-----
Sent: Thursday, December 18, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L
Hello:
I'm trying to figure out the new 9i outer joins.
I can get a single table outer join working without any issues. But seem to
keep getting errors when trying to do a two table outer join. I know it is
just something with my syntax. Could anyone provide a quick sample, thanks
in advance.
A:= Base Table
B:= Child Table 1
B:= Child Table 2
select a.emp,
b.ValueA
c.ValueB
>From base_table A outer join child_Table1 B
on A.emp=B.Emp.......
I know the old way of
select a.emp,
b.ValueA
c.ValueB
>From base_table A, child_Table1 B, child_Table2 C
where A.emp=B.Emp(+)
and A.emp=C.Emp(+)
_________________________________________________________________
Grab our best dial-up Internet access offer: 6 months @$9.95/month.
http://join.msn.com/?page=dept/dialup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay Wade
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Toepke
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
