Help with two table query

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

Responses

Browse pgsql-general by date

  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?