Hi I am calling two tables from two different data sources. they are connected with Key name date. I cannot get the sum of sales between the start date & End date(Refer 3rd Table as a sample) . Plz help me out
Table 1 (Table from MySQL)
| Date |
Sales |
| 1/1/2023 |
345 |
| 1/2/2023 |
675 |
| 1/3/2023 |
34 |
| 1/4/2023 |
45 |
Table 2 (Table from SQL)
| Date |
Start Date |
EndDate |
| 1/2/2023 |
1/2/2023 |
1/4/2023 |
| 1/3/2023 |
1/3/2023 |
1/4/2023 |
I need output like this
Table 2
| Date |
Start Date |
EndDate |
sum sales between the start date & End date |
| 1/2/2023 |
1/2/2023 |
1/4/2023 |
754 |
| 1/3/2023 |
1/3/2023 |
1/4/2023 |
79 |
