Non Matching Records in Two Tables - Mailing 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