Re: Outer joins
That's the old OUTER syntax. I am looking for the syntax for the new ANSI OUTER JOIN
stuff. It is not in my manual.
Thomas Parsli wrote:
> The Beef Man <paulhoward@home.com> writes:
>
> > I am looking at the "FROM clause" in the manual and it makes no mention of the
> > ANSI outer join syntax. I am looking for something like FULL|LEFT|RIGHT OUTER
> > JOIN <table> ON <join clause> but I can find no such beast. Do you know where
> > this might be documented?
>
> If you have the manual you could look up OUTER in the index;)
> SELECT foo FROM bar OUTER baz WHERE .... if minds serves me right?>
> Thomas
The new syntax did not make the manuals it is in the release notes file
for the SQL manual.
Art S. Kagel
The Beef Man wrote:
>
> That's the old OUTER syntax. I am looking for the syntax for the new ANSI OUTER JOIN
> stuff. It is not in my manual.
>
> Thomas Parsli wrote:
>
> > The Beef Man <paulhoward@home.com> writes:
> >
> > > I am looking at the "FROM clause" in the manual and it makes no mention of the
> > > ANSI outer join syntax. I am looking for something like FULL|LEFT|RIGHT OUTER
> > > JOIN <table> ON <join clause> but I can find no such beast. Do you know where
> > > this might be documented?
> >
> > If you have the manual you could look up OUTER in the index;)
> > SELECT foo FROM bar OUTER baz WHERE .... if minds serves me right?> >
> > Thomas