How to update table by date with two columns in another table which has specific range of date in a year?

Question

I have two tables, the first is MainDB where I want to get the service fee in columns MainDB.COL5 equal to ServiceFEE.COL_5, the primary key is the date in MainDB.COL_4 which falls in range between two ServiceFEE.COL_3 and ServiceFEE.COL_3.

for the service fee period may consider by start date and end date some countries may have many different of service fees in a year

UPDATE MainDB SET MainDB.COL_5 = ServiceFEE.COL_5 WHERE MainDB.COL_4 = BETWEEN ServiceFEE.COL_3 and ServiceFEE.COL_4