Select in DateTime Range

Dear Community,

Have a task to align production execution and registered sensors values during goods production.
One table has the date and time of the start of production and the date and time of the end of production each time a unique product. Another table keeps a log of the values of dozens of different temperature sensors. Logs are recorded in a date and time format, every two seconds. The only possible relationship between the tables is the date and time.

The task is this: when choosing a product in one table, filter the sensor values that were recorded from the beginning of the production of the product to its end. Some kind of select in DateTime range...