Non Matching Records in Two Tables
От | Ken Hill |
---|---|
Тема | Non Matching Records in Two Tables |
Дата | |
Msg-id | 1139433024.2044.48.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Non Matching Records in Two Tables
Re: Non Matching Records in Two Tables Re: Non Matching Records in Two Tables Re: Non Matching Records in Two Tables |
Список | pgsql-sql |
I need some help with a bit of SQL. I have two tables. I want to find records in one table that don't match records in anothertable based on a common column in the two tables. Both tables have a column named 'key100'. I was trying somethinglike:<br /><br /> SELECT count(*)<br /> FROM table1, table2<br /> WHERE (table1.key100 != table2.key100);<br /><br/> But the query is very slow and I finally just cancel it. Any help is very much appreciated.<br /><br /> -Ken
В списке pgsql-sql по дате отправления: