| 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: | Whole Thread | Raw Message | 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? |