How to link two tables and get data from one table based on two dates?

[mikefiorelli]

[gbritton]

select *
from custtable ct
join timeframetable tft
on ct.customerid = tft.customerid

[JohnNars]

That was very helpful, indeed. Thanks!