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 Bon 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).