admin 2021.10.01 21:46 Views : 46
Select
SUPPORTER_ID,MISSIONARY_ID,AMOUNT,CONTRIBUTION_DATE from CONTRIBUTION
JOIN SUPPORTER
ON SID = CONTRIBUTION.SUPPORTER_ID
WHERE CONTRIBUTION_DATE BETWEEN :P123_FROM AND :P123_TO
AND SUPPORTER.BOARD = 'BOARD'