talk about UNION.

Is there a difference in using UNION and UNION ALL in firebird?

On Sun, 23 Jan 2005 12:28:43 +0100, Aage Johansen <aagjohan@...> wrote:
>
> 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.
>
>
> Yahoo! Groups Links
>
>
>
>
>