Re: Outer Join Syntax - Quick Question

EGPWells wrote: > 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 > > that it will be easy to port our SQL Server/SQL Anywhere/Oracle > databases > to Informix. > I think it's ANSI standard (at least Informix always claims to be, but then again, so did Sybase and at least 10.x of Sybase was very different.)For Informix, simply put "OUTER" in front of the table to be outer-joined to, as in SELECT a,b,c FROM some_table, OUTER another_table... This makes a lot more sense than the *= and =* used by Sybase and Microsoft's SQLServer. (at least to me anyway). (I have heard that Sybase 10.x was not fully ANSI-compliant, though not from anyone at Sybase). > Also, have triggers always been supported, or were they introduced in > a > particular version of Informix? If so, which one? > Triggers have not always been supported. Someone else will probably give you the exact version, but I believe they have been supported since "ante-diluvian" times (since at least 5.x). > Thanks for your time, > > -Beth Wells > egpwells@aol.com -- - Danny Wright danwright@bigfoot.com #include <stddisclaimers.h> * God is real, unless declared as an integer. * Why do programmers get Halloween and Christmas mixed up? Because 0CT(31) == DEC(25) * I'd love to change the world, but I can't get into the source code. * /nev/dull