Non Matching Records in Two Tables - Mailing list pgsql-sql

From Ken Hill
Subject Non Matching Records in Two Tables
Date
Msg-id 1139433024.2044.48.camel@localhost.localdomain
Whole thread Raw
Responses Re: Non Matching Records in Two Tables  (Frank Bax <fbax@sympatico.ca>)
Re: Non Matching Records in Two Tables  (Markus Schaber <schabi@logix-tt.com>)
Re: Non Matching Records in Two Tables  (Patrick JACQUOT <patrick.jacquot@anpe.fr>)
Re: Non Matching Records in Two Tables  ("BigSmoke" <bigsmoke@gmail.com>)
List 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 by date:

Previous
From: "Owen Jacobson"
Date:
Subject: Re: Delete with join -- deleting related table entries?
Next
From: Frank Bax
Date:
Subject: Re: Non Matching Records in Two Tables