RE: Simple SQL Question

From: Kevin Toepke <ktoepke_at_rlcarriers.com>
Date: Thu, 18 Dec 2003 11:29:26 -0800
Message-ID: <F001.005DA54D.20031218112926@fatcity.com>

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kevin Toepke
  INET: ktoepke_at_rlcarriers.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:29:26 CST