Re: SQL construct not supported in informix ?

vk02720@my-deja.com (vk02720) wrote in message news:<4d814faa.0307170740.3e983552@posting.google.com>... > The following SQL construct does not work in Informix 7.3 > select a,b from > (select col1 a, col2 b from mytable)> > This works in Oracle. > Is this part of SQL standard or an Oracle extension ? > > TIA You can achieve the same result by doing: select a, b from Table(Multiset(select col1 as a, col2 as b from mytable)) as foo However, some other databases would try to expand the subquery and find more efficient joins to table in the outer query if there are any. Informix won't.