Join two tables with intersecting dates

Hello,   I have - a table with the absences of the agents of my enterprise : start and end dates, number of hours missed - a table with the contracts of the agents : start and end dates, number o...