Need help with query

I have two tables:
table 1 contains company names and phone numbers. table 2 contains phone calls made by phone number. I need to join the two tables by phone number.

The problem is some companies own a complete exchange so while some calls would be a join of company phone number (214)-123-4567 in table 1to all phone calls made by (214)-123-4567 in table 2 other companies need to join (214)-123 to all calls between (214)-123-000 and (214)-123-9999

can this be done in a single query?

thanks,
Bob Received on Mon May 18 1998 - 12:46:33 CDT