You should be able to CAST() the second field to Currency as is required (see below).

>Hi All:
>
>How do I fix the following to make it UNION compatible? It's not compatible since one field is numeric and the other is currency. This is just a scaled-down example. In the real system, I'm not able to change the definition of Currency in File1.

CLOSE ALL

CREATE TABLE ('file1') ;
	(fname C(30), ;
	extprice    Y)
	
CREATE TABLE ('file2') ;
	(fname   c(30))	
	
SELECT fname, extprice ;
FROM file1 ;
union all ;
SELECT fname, CAST( 0 AS Y ) as extprice ;
FROM file2 ;
INTO CURSOR blarg

>
>Thanks,
>
>Yossi