Chad,
> 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)
You're gonna feel silly ... you just need to replace the second "WHERE"
with an "AND", i.e. ...
AND NOT EXISTS (
SELECT cr.phonenum ...
-Josh Berkus