Re: Select In From Clause

Jeremy Rickard wrote: > > 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 I agree with u here, and I suspect I'm missing what they are wanting to really do. James Burton.