Date: 06/07/05 (MySQL Communtiy)    Keywords: mysql, sql, google

I have two tables. They both use the same user ids. I need to compare the tables and get all the rows in table A that aren't in table B. I suspect I need a JOIN. I have read the MYSQL.com stuff on joining, and I've tried to find other tutorials on this, but I'm not having much luck finding something that addresses the issue. If you have advice, links or at least good Google search terms, I'd be most appreciative.

Source: http://www.livejournal.com/community/mysql/58909.html