Re: left outer join

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Mon, 14 Jan 2002 21:04:31 -0000
Message-ID: <%FH08.19844$_x4.2997816@news2-win.server.ntlworld.com>

"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.

> 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. Received on Mon Jan 14 2002 - 15:04:31 CST