SQL union and ODBC

Hello !

Try create a VIEW using the two 'selects' and the union ant then use
it.

I use it with ORACLE 7 and never had any trouble.

DiasCosta
dco...@lnec.pt

Quote
>All (long ?) queries which apply the UNION operator to two base SELECT
>statements fail with ODBC where they worked fine with the local IB
>server.