Re: *** Unwanted OUTER join, please help ***

Several people have asked to see the entire select statement and all I see is a repeat of the FROM. No SELECT, no WHERE, no nothin'...... Since you keep sending the same information over and over despite the list's requests, wouldn't that make you a spammer?!?!? Gasp! --- spammers_suck@my-deja.com > wrote: >Forgive the reposting. I need an answer and want to change the subject >line to attract more guru attention :) > > >Its a strange thing. > > I want do : > > FROM a, outer b, outer c, (d, outer e) > > Informix insists that I do : > > FROM a, outer b, outer c, outer (d, outer e) > > > But I don't want d to be an outer join with a ! It returns unwanted >"extra" rows. I want it to be a "regular" join. > > Any ideas? > > Why this apparent limitation? > > >Sent via Deja.com http://www.deja.com/ >Before you buy. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net