Select


CLDOC_FD AS CLAVE,
CLPRO_FD,
CANTI_FD,
TREGI_FD,
CLDOC_FD,
FEDOC_FD AS FECHA

From "C:\datoschesko\BASES2\remisiod.dbf"
union
Select


CLDOC_OD AS CLAVE,
CLPRO_OD,
CANTI_OD,
TREGI_OD,
CLDOC_OD,
FEDOC_OD AS FECHA

From "C:\datoschesko\BASES2\COMPRASD.dbf"
UNION

Select


CLDOC_MI  AS CLAVE,
CLPRO_MI,
CANTI_MI,
REFMO_MI,
111100+TIMOV_MI,
FEDOC_MI AS FECHA

From "C:\datoschesko\BASES2\MOVINVEN.dbf"

ORDER BY FECHA,CLAVE