today:
198
yesterday:
221
Total:
1,109,854

SQL MISSIONARY_SUB

admin 2018.06.25 14:34 Views : 257

insert into MISSIONARY_SUB
Select 
MISSIONARY_ID,SUPPORTER_ID,AMOUNT,CONTRIBUTION_DATE 
from CONTRIBUTION 
where UPPER(:P9_MISSIONARY_ID) = MISSIONARY_ID 
and :P9_YEAR = to_number(to_char(CONTRIBUTION_DATE,'YYYY'))
order by SUPPORTER_ID,CONTRIBUTION_DATE;