How should the output look like ?
Bob McConnell <bobmc_at_cyberramp.net> schrieb im Beitrag
<35606808.822253027_at_news.internetmci.com>...
> 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 Tue May 19 1998 - 08:29:23 CDT
