today:
21,914
yesterday:
37,202
Total:
5,861,305

Technology

TWO TABLE JOIN AND CONDITION

admin 2021.10.01 21:46 Views : 129

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'