Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Outer Join
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
![]() |
![]() |