From: | "Chad Thompson" <chad(at)weblinkservices(dot)com> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com>, "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Inner join syntax |
Date: | 2002-10-11 16:30:02 |
Message-ID: | 039e01c27143$73704400$32021aac@chad |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Sometimes i cant see the trees for the forest. :-)
Thanks Josh, I was making it too complicated
Chad
----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Chad Thompson" <chad(at)weblinkservices(dot)com>; "pgsql-novice"
<pgsql-novice(at)postgresql(dot)org>
Sent: Friday, October 11, 2002 10:24 AM
Subject: Re: [NOVICE] Inner join syntax
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kirby Krueger | 2002-10-11 20:08:34 | Problems with c, compiling, libraries |
Previous Message | Josh Berkus | 2002-10-11 16:24:16 | Re: Inner join syntax |