Hello all :-)

I try to do this simple Sql statement:

SELECT DESCR,NULL FROM TAB1
UNION ALL
SELECT DESCR,IDX FROM TAB2

with Access, DB2 and other this works fine, with IB it doesn't.
I have tried with NULL,0,'',"" and other but nothing.

Any suggestions?

Thanks in advance

Giorgio.