From: Aaron Fischer
Date: October 26 2007 3:27pm
Subject: Comparing keys in two tables
List-Archive: http://lists.mysql.com/mysql/209701
Message-Id: <7609BE5A-F9B6-4A6E-AEF1-6A99D1F94FAA@email.smith.edu>
MIME-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-Transfer-Encoding: 7bit

Greetings!

I have a problem that it seems would best be solved using  
subqueries.  However, I am working on a server that is running MySQL  
3.23.58, so subqueries are not available to me.

What I am trying to do:
I have two tables, each containing approximately 37,000 records.  I  
want to compare the index field in Table A to the index field in  
Table B.  I would like to see all records where the index in Table A  
does not exist in Table B.

Thoughts?  Suggestions?

Much appreciated!

-Aaron