Subject Re: [firebird-support] unions in sub-selects
Author Aage Johansen
Ed Dressel wrote:
>
> FB balks at doing a union in a subquery, e.g.:
>
> select * from Table1
> where Table1_ID in (Select Table1_ID from Table2 union Select
> Table1_ID from Table3)
>
> Is the only way to achieve that via a stored procedure?
>


What kind of "balk"?
Does Fb just complain about Table2.Table1_ID having a different type than
Table3.Table1_ID ?
Probably not.
Maybe "union all" will work? Since "union" may return duplicates it
doesn't really make sense to allow this.


--
Aage J.