Re: SQL construct not supported in informix ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • vk02720

    Re: SQL construct not supported in informix ?

    "Art S. Kagel" <kagel@bloomber g.netwrote in message news:<pan.2003. 07.17.18.01.18. 408954.15473@bl oomberg.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 ) ?
    Any good website for SQL standard ?
Working...