today:
311
yesterday:
452
Total:
1,586,249

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'