MINUS emulation?
От | Barry Baldwin |
---|---|
Тема | MINUS emulation? |
Дата | |
Msg-id | 319A9588FB5ED2119FAC00A0C912E3292785C0@INDYMEEXCH обсуждение исходный текст |
Ответы |
Re: [SQL] MINUS emulation?
Re: [SQL] MINUS emulation? |
Список | pgsql-sql |
Hi all, I'm trying to do a query that returns all the records in one table unless they exist in another table. For example the first query I tried was this; Select A.field_id, A.data, B.field_id, B.data from table_1 A, table_2 B where A.field_id <> B.field_id; This query resulted in no records being returned, I believe this is because Table_2 is empty. I then tried : Select field_id, data from table_1 minus Select field_id, data from table_2; This didn't work because the Minus directive isn't recognized. Does anyone have a suggestion on how I might accomplish this? TIA, Barry
В списке pgsql-sql по дате отправления: