Dates Between Dates Diff Tables

Hi,  Is there a way to compare dates between two tables, and say    if "TRANS_DT" is less than "Effective Date" in one row, but greater than "Effective Date" in the previous row, use "Grade" for...