[amerika111]

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'