Re: SQL construct not supported in informix ?

vk02720_at_my-deja.com (vk02720) wrote in message news:<4d814faa.0307170740.3e983552_at_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. Received on Mon Jul 21 2003 - 21:04:36 CEST