Re: Select In From Clause

Posted in 1997

Nils Myklebust — Tue, 24 Jun 1997 10:20:11 GMT — source: Informix-list mailing list archive (1991-1998)

"Chez David" <dmitchell@SagentTech.com> wrote: :Hi all. : :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 This is not supported by 7.x. I think this is part of the SQL 3 standard wich is only in draft mode. It is (should be) supported by the Universal Server. One reason why we want the Universal Server (at a reasonable price) even for non fancy datatypes. There have been roumors that Informix will support the relevant parts of SQL 3 (such as this example) even in an upcoming release of the DSA/WorkGroup engines. The roumor was that DSA would be the Universal Server engine without datablades. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org