[juanmdq]

Hola, probá con esta consulta, en access me funciona pero en paradox no estoy seguro si lo que hago es correcto.

SELECT 
	 IDCliente,
	 Fecha,
	 Observacion AS Detalle, 
	 Total As Total_Debe,
	 0 As Total_Haber
FROM debes.db 
WHERE IDCliente = 1 
 
UNION ALL 
 
SELECT 
	IDCliente,
	Fecha,
	Observacion AS Detalle, 
	0 As Total_Debe,
	Total As Total_Haber 
FROM haberes.db 
WHERE IDCliente=1

Saludos.