I have a query:
select
distinct on (l.full_phone) l.full_phone, l.idfrom 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 = 16and l.list_of_lists_id = 170and 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
