Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Outer Join

Re: Outer Join

From: <markp7832_at_my-deja.com>
Date: 2000/02/14
Message-ID: <889pmi$3jf$1@nnrp1.deja.com>#1/1

In article <889bbe$ocs$1_at_nnrp1.deja.com>,   poludasucs_at_my-deja.com wrote:
> Hey..
> In my query, I am joining 5 tables. I will be
> using the first three conditions to filter out
> the data from the tables. Once this is done, I
> have to join the result to one another table.
> But the problem is when I include an outer join,
> it is not retrieving the records which are outer
> to the query. Is it not possible to get the
> records outer to the query if we have more than 3
> tables in the query??????????
>

To get an answer to your question I think you need to post your query or at least a striped down version of it so we can see the join and tell you if it follows all the rules.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 14 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US