Select In From Clause

Posted in 1997

Chez David — Mon, 23 Jun 1997 19:40:26 -0500 — source: Informix-list mailing list archive (1991-1998)

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