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 b...