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@postgresql.org)
>