Re: Full Join Problem

From: Christian Habermehl <Tauschen_Habermehl.Christian_at_fhtw-berlin.de>
Date: Tue, 4 Jan 2005 17:42:45 +0100
Message-ID: <33vvc1F44skekU1@individual.net>

pbewig_at_swbell.net write:

> select *
> from (select ...) a
> full join (select ...) b
> on a.xxx = b.xxx
> and a.yyy = b.yyy
>
> This causes an ORA-600 internal error.

it tried it and it works for me. I don't think ORA-600 indicates a problem with your SQL.

(maybe) a general question: why don't you use

select *

    from (select ...) a,
         (select ...) b
   where a.xxx = b.xxx
     and a.yyy = b.yyy

? the execution plan looks better...

Christian Received on Tue Jan 04 2005 - 10:42:45 CST