Re: SQL construct not supported in informix ?

vk02720 <vk02720@my-deja.com> wrote in message news:4d814faa.0307180627.1487aadb@posting.google.com... > "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.07.17.18.01.18.408954.15473@bloomberg.net>... > > On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote: > > > > > 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 > > > > Non-standard to the level of SQL that Informix supports. > > > > > > Art S. Kagel > > Thanks. > So what level of SQL standard does Informix support ? And again, is > this construct a SQL standard ( as compared to purely an Oracle > extension ) ? It's in SQL92, so not an Oracle extentsion (unlike that 'horrible' connect by :) In version 7.3, you'll have to select the derived table into a temp table first and then use that in your query. (version 8 (XPS) supports it directly - I belive, never used it, and version 9 has been covered by Kristofer) It /ought/ to be supported, since the result of any select is just another relvar, but there you go ... > Any good website for SQL standard ? Tried google ? Google is your friend -- RH