mmm lo hice afuera pero nose si sea lo optimo o la forma correcta
Código SQL
[-]
SELECT movs.id,movs.id,movs.id_per,per.clave,movs.id_ent,movs.id_cta,movs.motivo,movs.tipoMovs,movs.montoIn icial,movs.montoFinal,movs.usr,movs.ult_act FROM FMPR_PER per
INNER JOIN
(SELECT id,id_lib,id_per,id_ent,id_cta,'' AS motivo,tipoMovs,montoInicial,montoFinal,usr,ult_act
FROM FMPR_HIST_MOVS movs WHERE movs.id_ent=1 and movs.id_cta=1
union all
SELECT id,id_lib,id_per,id_ent,id_cta,motivo,tipoMovs,monto as montoInicial,'' AS montoF,usr,ult_act
FROM FMPR_SUPLEMENTOS supl where supl.id_ent=1 and supl.id_cta=1) as Movs
ON per.id=movs.id_per and per.clave='ene2011'