Query doesn't work

adr123 · #1 (**permalink**) 01-05-10, 12:57

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?

r937 · #2 (**permalink**) 01-05-10, 14:02

try it like this --

select * from (select id from test) any_alias_except_test

adr123 · #3 (**permalink**) 01-05-10, 16:01

Still doesn't work. BTW my Informix version is 10 FC8

adr123 · #4 (**permalink**) 01-06-10, 04:44

Found a solution. In Informix 10 it should be:

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

In Informix 11 this is fixed.

Internet Services

Web Development

Digital Marketing

Consumer Tech