Query to return customers with more than one type...

[mokamalx]

I'm trying to create a query that returns a list of customers that have more than one type of phone number (cell, home, business) in their "phone_type " drop down column. Any help would be appreciated.

[ck9663]

What do you have so far?


~~ CK

[mokamalx]

What I have so far...

select cst_id,
pht_code
cph_pht_key
from co_phone_type (NOLOCK)
LEFT JOIN co_customer (nolock) on pht_key=cst_key
LEFT JOIN co_customer_x_p hone (nolock) on cph_key=cph_pht _key
where pht_code = 'Billing'

Thanks for any help.

Mk