Select


CANTI_FD,
CLPRO_FD,
DEPRO_FD,
PUNPR_FD,
TDOCU_FD,
FEDOC_FD,
CLDOC_FD,canti_fd*1

From "C:\SIF2000\BASES\facturad.DBF"

where tdocu_fd is null and TREGI_F IS NULL

union 

Select


CANTI_FD,
CLPRO_FD,
DEPRO_FD,
PUNPR_FD,
TDOCU_FD,
FEDOC_FD,
CLDOC_FD,canti_fd*(1)

From "C:\SIF2000\BASES\RemisioD.DBF"

where tdocu_fd is null and TREGI_F IS NULL

union 

Select


CANTI_FD,
CLPRO_FD,
DEPRO_FD,
PUNPR_FD,
TDOCU_FD,
FEDOC_FD,
CLDOC_FD,canti_fd*(-1)

From "C:\SIF2000\BASES\DevolucD.DBF"

where tdocu_fd is null and TREGI_F IS NULL
order by CLPRO_FD,FEDOC_FD