Re: Select In From Clause

Posted in 1997

Harald Ums — Wed, 25 Jun 1997 09:51:21 GMT — source: Informix-list mailing list archive (1991-1998)

It's supported by Illustra and I guess Universal Server will support it. "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 > >TIA > > Harald Ums Tel : +49 (0)89-9507-5140 PRO 7 Televisions GmbH Fax : +49 (0)89-9507-5191 Bahnhofstra'e 28 D-80767 Unterf'hring e-mail: Harald.Ums@sevensys.de