Re: Select In From Clause

Posted in 1997

Jeremy Rickard — Tue, 24 Jun 1997 19:28:34 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <5onbvc$a0t@masters0.InterNex.Net>, 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 Does anyone want it to?! Personally, I think this could lead to some very ugly SQL queries. Can you think of any examples that couldn't be re-written as a "normal" query without looking at least as elegant? If this is really needed then I think it would be "prettier" to define T0 and T1 as temporary tables (using WITH or whatever construct is/becomes the standard for this). What's the general opinion on this form? -- Jeremy Rickard