From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Help with two table query |
Date: | 2002-02-23 15:21:35 |
Message-ID: | B9095DA2D217D511929B00A0C94989FE0BD669@obelix.askesis.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi everyone,
I have two tables. I want get all the rows (orderManagers) that are in table
2 that are not in table 1.
Table 1 has the following columns:
district
orderManager
salesItemType
priority
Table 2 has the following columns:
orderManager
salesItemType
priority
The query I came up with is:
SELECT Table2.orderManager FROM Table1, Table2
WHERE
Table1.district = '1990-01-01-00-02-04-000001'
AND
Table1.salesItemType = '1990-01-01-00-02-16-000001'
AND
Table2.salesItemType = '1990-01-01-00-02-16-000001'
AND
Table1.orderManager != Table2.orderManager
But this query does not produce the expected result. The query just returns
all orderManagers from Table2 that have the required salesItemType.
Can anyone help me with this?
TIA
Joost
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Sheehan | 2002-02-23 15:27:24 | Re: where can I find latest jdbc driver for postgresql? |
Previous Message | Tom Sheehan | 2002-02-23 15:10:36 | Re: where can I find latest jdbc driver for postgresql? |