I have a query:
select distinct on (l.full_phone) l.full_phone, l.id
from lists l inner join timezone tz on l.area_code = tz.area_code
inner join tiers t on phonenum_substr(l.full_phone) = t.npanxx
where l.client_id = 16
and l.list_of_lists_id = 170
and tz.greenwich = '-7'
and t.tier in ('A','B')
I am trying to add the following restriction to the above query. And I'm lost some where.
where not exists (
select cr.phonenum
from call_results cr
where client_id = 16
and l.full_phone = cr.phonenum)
In case its not clear I want the first query but dont want those numbers that are in call_results
Any Ideas?
TIA
Chad