Sum of value between the two dates, dates are in other table in two Column

[AT2023]

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