Re: Select In From Clause

Posted in 1997

Jeremy Rickard — Wed, 25 Jun 1997 19:08:04 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <01bc80e2$a25c3f50$8d286482@pc1954>, "Michael F. Nicewarner" <mnicewar@ibpinc.com> writes >Oddly enough DB2/MVS even supports this syntax. Really makes life easier >for me. >Mike Nicewarner >IBP, Inc. > >> :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. > As does DB2 common server (NT, UNIX, OS/2 etc.), of course. -- Jeremy Rickard