var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
try it like this --
select * from (select id from test) any_alias_except_test
Still doesn't work. BTW my Informix version is 10 FC8
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.