RE: Outer joins
The new syntax is in the IDS 7.3x Documentation Notes.
Look in your $INFORMIXDIR/release/en_us/0333 directory:
PERFDOC_7.3
SQLRDOC_7.3
SQLSDOC_7.3
These are also available at:
* http://www.informix.com/informix/resource/pubs/ids/0731uc5/sqt0731d.txt
* http://www.informix.com/informix/resource/pubs/ids/0731uc5/sqs0731d.txt
* http://www.informix.com/informix/resource/pubs/ids/0731uc5/per0731d.txt
-----Original Message-----
From: The Beef Man [mailto:paulhoward@home.com]
Sent: Wednesday, May 03, 2000 08:01
To: informix-list@iiug.org
Subject: 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