select id, id2, debito, credito, sum(debito-credito) over (partition BY id ORDER BY id, id2) saldo from ( select m.id, 0 id2, importe debito, 0 credito from m_cxc m where m.id=:id union all select c.id_m_cxc id, c.id id2, debito, credito from d_cxc c where c.id_m_cxc=:id ) a