grostoon wrote:

>
> I've just found that an SQL query like
> select * from table1 where table1.col1 in (select table2.col1 from table2 union select table3.col1 from table3)
> is not supported by FB 1.5.3 and produces the following error :
>
> Statement failed, SQLCODE = -104
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, char xxx
> -union
>
> Is this a known FB SQL syntax limitation ?

Yes.

> Does this kind of request work with FB2 ?*

Yes.

> Could it be possible to have it supported in final FB 1.5.4 ?

No.


Dmitry