Create column by comparing dates from different tables

Hello,

I want to add a column from another table after checking if a certain date falls between 2 dates from other columns.

I have 2 tables, Tables S/N used by

and

Table transactions (see both below).

I want to create a column 'ID nr.' in the transactions table (in red) and that ID nr. I get from 'Table S/N used by' after I checked if the date in the 'transactions table' falls between the 2 dates in 'Table S/N Used by'.

Hopefully it is clear what I mean.

Thanks,

Ralf