Re: Join ?

From: Kevin Nechodom <Kevin.Nechodom_at_hsc.utah.edu>
Date: 2000/06/29
Message-ID: <8jgb6b$kfk$1@coward.ks.cc.utah.edu>#1/1

http://www.itl.nist.gov/fipspubs/fip127-2.htm

INNER JOIN is part of the FIPS optional features. Section 14.1.4 deals with table joins. Oracle has not elected to implement them.

Kevin Nechodom
University of Utah

"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message news:39520D35.1F57F702_at_edcmail.cr.usgs.gov...
>
> > But it is more complex than with JOIN. My question is : is JOIN
supported by
> > Oracle ? Is there an alternative ?
>
> Xavier,
>
> JOIN is not part of the ANSI SQL-92 standard. Oracle does not support
> the JOIN operator. As others have responded in this thread, there is an
> alternative. It may not perform exactly as you are used to, but you can
> do what you want.
>
> HTH,
> Brian
>
>
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Thu Jun 29 2000 - 00:00:00 CDT