Help with two table query
От | Joost Kraaijeveld |
---|---|
Тема | Help with two table query |
Дата | |
Msg-id | B9095DA2D217D511929B00A0C94989FE0BD669@obelix.askesis.nl обсуждение исходный текст |
Ответы |
Re: Help with two table query
|
Список | 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
В списке pgsql-general по дате отправления: