Simple SQL Question

From: Jay Wade <fish_dba_at_hotmail.com>
Date: Thu, 18 Dec 2003 11:19:32 -0800
Message-ID: <F001.005DA54C.20031218111932@fatcity.com>

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: fish_dba_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Thu Dec 18 2003 - 13:19:32 CST