today:
431
yesterday:
719
Total:
1,770,215

Technology

TWO TABLE JOIN AND CONDITION

admin 2021.10.01 22:46 Views : 33

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'