admin 2019.05.28 22:00 Views : 379
select CONTRIBUTION_DATE,AMOUNT,m.MNAME,m.MKNAME from CONTRIBUTION c,MISSIONARY m
where c.MISSIONARY_ID = m.MID AND
SUPPORTER_ID = :P59_SUPPORTER_ID
AND TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE,'YYYY')) = :P59_YEAR