| From: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Query Help |
| Date: | 2000-12-28 12:19:15 |
| Message-ID: | 5.0.2.1.2.20001228071859.040f8e80@pop.mindspring.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Thank you to everyone with their suggestions.....
Where on the PostgreSQL site would I have found more info on the NOT EXISTS
At 11:20 AM 12/27/00 -0500, you wrote:
>What do I have to do a query where information in table1 is not in table2
>
>I am looking for something like
>
>Select table1.firstname where table1.firstname is not in table2.firstname
>and table2.date='yesterday'
>
>I tried
>Select table1.firstname where table1.firstname != table2.firstname and
>table2.date='yesterday'
>
>and that did not work just listed everyone....
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Peterson | 2000-12-28 14:09:54 | Re: Tree structure table normalization problem (do I need a trigger?) |
| Previous Message | Jens Hartwig | 2000-12-28 10:55:02 | Strange Execution-Plan for NOT EXISTS |