Cláudia wrote:

>
> Hello,
> When I try to execute the sql command:
> SELECT PAISID
> FROM PAIS
> UNION
> SELECT UFID
> FROM ESTADO
> I receive the following error message:
> "Dynamic SQL Error
> SQL error code =3D -104
> Invalid command
> Data type unknown"
> =20=20
> Could someone help me?

You will probably need to CAST the two fields (PAISID and UFID) to the same
type.

It is usually easier to answer a question if some metadata is provided -
like the type of fields in the query.


--
Aage J.