Creating Intervals between list of dates

[ShannaJJ27]

Hi all,
I have a table with a list of dates:
EmployeeID, BranchID, ContractStartDate
1, 65, 24-06-2019
2, 57, 06-07-2016
3, 23, 13-11-2017
1, 57, 05-03-2018
EmployeeID, Name, PaidDate ,Salary
1, John, 25-07-2019, 2500
1, John, 25-06-2019, 2500
1, John, 25-05-2019, 2000
1, John, 25-04-2019, 2000
1, John, 25-03-2019, 2000
etc...

I'd like to link these tables:
So when the contract date changes with a different branchID the salaries there after will be linked to that branch.

Result:
EmployeeID, Name, PaidDate,Salary, Branch ID
1, John, 25-07-2019, 2500 , 65
1, John, 25-06-2019, 2500, 65
1, John, 25-05-2019, 2000, 57
1, John, 25-04-2019, 2000,57
1, John, 25-03-2019, 2000, 57