Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    3

    Unanswered: Query doesn't work

    Hi all! I execute the following query
    select * from (select id from test) test
    but informix tells me that i have a syntax error
    The same SQL works great on other dbs. What's the problem here?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try it like this --

    select * from (select id from test) any_alias_except_test
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2010
    Posts
    3
    Still doesn't work. BTW my Informix version is 10 FC8

  4. #4
    Join Date
    Jan 2010
    Posts
    3

    Found solution for derived tables

    Found a solution. In Informix 10 it should be:

    select * from table(multiset(select id from test)) test

    In Informix 11 this is fixed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •