Re: Outer Join Syntax - Quick Question

Posted in 1997

David Williams — Wed, 20 Aug 1997 04:00:29 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <19970820000200.UAA21279@ladder01.news.aol.com>, EGPWells <egpwells@aol.com> writes >Could someone please tell me what then syntax is for an outer join using >Informix? Is it ANSI standard? I'm trying to convince people at work select tab1.col1, tab2.col2 from tab1, outer tab2 where tab1.col1=tab2.col2 >that it will be easy to port our SQL Server/SQL Anywhere/Oracle databases >to Informix. > >Also, have triggers always been supported, or were they introduced in a >particular version of Informix? If so, which one? > Stored procedures added 5.00 Triggers added 5.01 >Thanks for your time, > >-Beth Wells >egpwells@aol.com -- David Williams