I certainly understand sensitive data. Many of us around here work with sensitive data as a normal part of our day. For these types of things you just need obfuscate the data but keep it representative of the issue. Certainly nothing wrong with changing column names and only including columns relevant to the issue at hand. That makes it an example of how to do whatever it is you are doing and does reveal any real actual information.

I was pretty sure that all you needed was to join those two tables until I ran into this:

I have no idea what that means.

I was thinking initially that you wanted something like you were trying to use streetranges columns as some way to validate what is there.

Completely blind due to no information but here are a couple of shots in the dark.

Select

*

from streets s

join streetranges sr on sr.streetnumber = s.streetnumber

join streetranges sr2 on sr.streetname = s.streetname

OR MAYBE...

select *

from streets s

where

calltime >= 'Sometime'

and

street in (select streetname from streetranges)

and

streetnumber >= (select min(streetfrom) from streetranges)

and

streetnumber <= (select min(streetto) from streetranges)