Subject | Re: [firebird-support] unions in sub-selects |
---|---|
Author | Aage Johansen |
Post date | 2005-02-09T23:04:42Z |
Ed Dressel wrote:
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.
>What kind of "balk"?
> 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?
>
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.