Does this give you what you are looking for?

Select

*

from

streets s

inner join streetranges sr

on (s.street = sr.streetname and

s.streetnumber >= sr.streetfrom and

s.streetnumber <= s.streetto)

where

calltime >= 'Sometime' and

sr.streetcategory = 'CFMH';