Please find attached "".
We need to have the first table join to the second table so that;
If DATE_1 >= DATE_2, then use DATE_2 until a new DATE_2 occurs
No stored procedures, just simple joins such as LEFT OUTER JOIN, INNER JOIN, etc. Excel was only used to illustrate the problem to be solved.