Compare two tables for rate increase

Hi,   Hoping someone can assist with this please for a custom column.    I have two tables, one with a list of staff, payment dates and amount, the other table has rate increase start date/end da...