Re: left outer join

From: Andre Grosse <ag17_at_inf.tu-dresden.de>
Date: Mon, 14 Jan 2002 22:59:10 +0100
Message-ID: <3C4354AE.7020108@inf.tu-dresden.de>

Keith Boulton wrote:

> "Andre Grosse" <ag17_at_inf.tu-dresden.de> wrote in message
> news:3C431BBC.9070302_at_inf.tu-dresden.de...
>
>

>>select count(*) from table1 left join table2 on table2.id=1;
>>

>
> Not sure what you're trying to get.
>
> You are not actually joining table 1 and table 2.
>
>

yes, thats a constructed example. but it should be possible.

>>i get also some internal errors (a lot of crash-logs) ORA-03113 with
>>further conditions in selects with above left joins. so there seems to
>>be something wrong in oracle?!
>>

>
> Support for this syntax is new (I think in 9i). You need to wait a few years
> for Oracle users to debug it, like any other new feature or use the oracle
> syntax.
>

ok, here in oracle-style-syntax:

select count(*) from table1,table2 where table2.id(+)=1;

same problem as above...

-- 
Andre Grosse

Received on Mon Jan 14 2002 - 15:59:10 CST