Hello everbody and happy new year,

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 ?
Does this kind of request work with FB2 ?*
Could it be possible to have it supported in final FB 1.5.4 ?

Best regards,

Toon.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]