Re: outer join...
From: Tony Hunt <tonster_at_bigpond.net.au>
Date: Mon, 17 Sep 2001 12:32:51 GMT
Message-ID: <T3mp7.61668$bY5.298761_at_news-server.bigpond.net.au>
Date: Mon, 17 Sep 2001 12:32:51 GMT
Message-ID: <T3mp7.61668$bY5.298761_at_news-server.bigpond.net.au>
What is the difference between Outer Join and Inner Join?
Oracle has Equijoins, Non-Equijoins and Outer Join.
"kawai" <kawai_at_nospam.com> wrote in message
news:3BA577BA.CF19935B_at_nospam.com...
> 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
Received on Mon Sep 17 2001 - 14:32:51 CEST