Subject | Re: [firebird-support] select ... in (select ... union select ...) |
---|---|
Author | ian |
Post date | 2007-01-09T13:21:55Z |
grostoon wrote:
regards
ian
>It works (for me) in FB2.
>
> 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
>
> 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 ?
>
regards
ian