| Subject | Re: RES: VIEW CREATES ON FB 2.5 BUT DO NOT CREATE ON FB 1.5 |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2016-12-01T11:07:39Z |
29.11.2016 13:45, 'Israel Pinheiro' wrote:
select A1, B1, C1
union
select A2, B2, C2
union
select A3, B3, C3
Data types for (A1, A2, A3) should match exactly. The same for B and C.
Dmitry
>Check datatypes of all union parts, i.e.
> Invalid Token. Dynamic SQL Error. Invalid Command Data Type unknown
select A1, B1, C1
union
select A2, B2, C2
union
select A3, B3, C3
Data types for (A1, A2, A3) should match exactly. The same for B and C.
Dmitry