Aaron Cannon wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all. I hope this is the right place to ask this. I have two tables, A and B. Each of these tables has a column with integers. The column in table A is C and the one in B is D.
SELECT c.value FROM c WHERE c.value NOT IN (select value FROM d); Works for me in mysql 5 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]