Re: outer join...
From: T. Schwickert <schwickert_at_yahoo.com>
Date: Mon, 17 Sep 2001 09:44:40 GMT
Message-ID: <cCjp7.2599$p77.3864_at_www.newsranger.com>
Date: Mon, 17 Sep 2001 09:44:40 GMT
Message-ID: <cCjp7.2599$p77.3864_at_www.newsranger.com>
Hi,
On Mon, 17 Sep 2001 12:10:34 +0800, a person called kawai thought ...
>
>Does anyone know that if Oracle supports ANSI standard inner join and
>outer join? (ANSI standard: "tableA INNER JOIN tableB ON colA = colB"
>for inner join and "tableA LEFT OUTER JOIN tableB ON colA = colB" for
>outer join)
>
>the current syntax " =(+) " does not seems to be an ANSI standard.
>
>
>kawai
Oracle below version 9 doesn't support this syntax. With 9i it's introduced ...
Hth
Thomas
Received on Mon Sep 17 2001 - 11:44:40 CEST