Re: Oracle vs Informix...

> >Can you please tell me how the outer join is flawed? I have an >application that I just ported to Informix, and this would be a big >problem that I need to be aware of. > >Thanks, > >Bill MacLean It's been about 2 years since I've worked with it, and can't find my notes so I expect to get flamed for my comments since I can't back them with docs now. AARRGG! Anyway, I expect that the NOT IMPLEMENTED functions are in now, since that was the easy stuff. The OUTER JOIN was core though, and I expect that will be there forever. It was (umm, real stretch on the memory here) applying selection criteria on the outer portion of the join (dummy fields or something like that), which ended up excluding records that should have been included. Please don't ask for more since I can't find my docs and no longer have Informix here to play with. Sorry. I got burned really bad, and am still recovering. MAKE SURE YOU CHECK THE RESULTS OF OUTER JOINS AGAINST WHAT IS EXPECTED!