Re: Help with two table query

SELECT orderManager,salesItemType,priority
FROM table 2
WHERE orderManager NOT IN (SELECT orderManager
FROM table1);

This will give you the result you are looking for.

Note i made the assumption that both orderManager fields are the same
datatype

Darren Ferguson

On Sat, 23 Feb 2002, Joost Kraaijeveld wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>