RE: outer joins

Posted in 2000

Bernstein, Rick — Thu, 24 Feb 2000 11:34:32 -0800 — source: Informix-list mailing list archive (1991-1998)

It is the release notes for IDS 7.31. * SQLSDOC_7.3 * SQLTDOC_7.3 * PERFDOC_7.3 in the $INFORMIXDIR/release/en_us/0333 directory. Information is also available at Informix's Web site: http://www.informix.com/informix/resource/pubs/ids/0731uc5/sqs0731d.txt http://www.informix.com/informix/resource/pubs/ids/0731uc5/sqt0731d.txt -----Original Message----- From: Red Valsen [mailto:red_valsen@yahoo.com] Sent: Thursday, February 24, 2000 6:41 AM To: informix-list@iiug.org Subject: outer joins Is there new syntax available for outer queries, such as "left outer join," etc.? If so, where is this documented? I could not find it in the SQL Syntax manuals. Also, why are outer queries so much more expensive to execute?