Select


f.CLDOC_FD,
f.CLPRO_FD,
f.FEDOC_FD AS FECHA,
'VENTAS'



From "c:\SIF2000\BASES CARMEN\7-2-2006\REMISIOd.DBF" as f
union
Select

c.CLDOC_OD,
c.CLPRO_OD,
c.FEDOC_OD AS FECHA,
'COMPRA'
From "c:\SIF2000\BASES CARMEN\7-2-2006\comprasd.DBF" as c
ORDER BY FECHA