Re: Select In From Clause

Posted in 1997

David Williams — Wed, 25 Jun 1997 01:00:58 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5opfk1$cn4@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> writes >>From: Jeremy Rickard <Jeremy@jbdr.demon.co.uk> >>Date: Tue, 24 Jun 1997 19:28:34 +0100 >>X-Informix-List-Id: <news.39612> >> >>Chez David <dmitchell@SagentTech.com> writes: >> >>>Anyone know if Informix ( 7.x ) supports SQL of this form? SQL Server and >>>Oracle seem to. >>> >>>SELECT >>>T0.C0, T1.C0 >>>FROM >>>( SELECT JOB_ID AS C0 FROM JOBS ) T0, >>>( SELECT JOB_ID AS C0 FROM EMPLOYEE ) T1 >>>WHERE >>>T0.C0 = T1.C0 > > >Well, I don't know about the general opinion, but I'm in favour of it. > Nice idea but a little too complex for me to be happy with. I'd hate to try and debug something like this with several ...col1 as col2... and ,,,tab1) tab2 clauses in it.. I could imagine some truely horrendous queries could be created with it... >Yours, >Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> -- David Williams