SQL to join tables and get value from one table that has most recent date closest to date of parent record

Question: I have two tables, one a parent of the other, let's call them CUST and CUST_ADDR. Each table is a history table, so each time a value in one of the data fields changes, another record is added with the new value and a date it was changed. S...