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
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