Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news3.rdc2.on.home.com.POSTED!not-for-mail
From: "Paul Quenneville" <paulq@home.com>
Newsgroups: comp.databases.oracle.misc
References: <9q1hdv$5le$1@reader1.imaginet.fr>
Subject: Re: Select statement on 2 linked tables
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <Cb_w7.40484$5h5.18308881@news3.rdc2.on.home.com>
Date: Wed, 10 Oct 2001 15:55:14 GMT
NNTP-Posting-Host: 24.156.176.182
X-Complaints-To: abuse@home.net
X-Trace: news3.rdc2.on.home.com 1002729314 24.156.176.182 (Wed, 10 Oct 2001 08:55:14 PDT)
NNTP-Posting-Date: Wed, 10 Oct 2001 08:55:14 PDT
Organization: Excite@Home - The Leader in Broadband http://home.com/faster
Xref: easynews comp.databases.oracle.misc:70131
X-Received-Date: Wed, 10 Oct 2001 09:00:35 MST (news.easynews.com)

SELECT T1.val1, T1.val2, T2.val1, T2.val2
FROM T1, T2
 where T1.K1 = T2.K1(+)
 and T1.K2 = (T2.K2(+)

"Matthieu DEGLIN" <mdeglin@remove-me.partner.auchan.com> wrote in message
news:9q1hdv$5le$1@reader1.imaginet.fr...
> I've 2 tables T1 et T2. Those tables are linked by two fields: T1.K1 /
T2.K1
> and T1.K2 / T2.K2.
>
> I'm trying to build a request that give me T1.val1, T1.val2, T2.val1,
> T2.val2 EVEN IF there isn't any lines in T2 linked to T1. In this case,
the
> fields T2.val1 and T2.val2  should be returned NULL.
>
> The following request doesn't work !
>
> SELECT T1.val1, T1.val2, T2.val1, T2.val2
> FROM T1, T2
> where T1.K1 = +(T2.K1)
> and T1.K2 = +(T2.K2)
>
> It returns only T1 values for which a T2 is linked to.
>
> Can somebody help me ?
>
> Thanks for Help.
>
>
>
>