today:
125
yesterday:
665
Total:
1,581,338

Technology

TWO TABLE JOIN AND CONDITION

admin 2021.10.01 21:46 Views : 20

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'