Aaron Fischer wrote:
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.
Use an "exclusion join:"
SELECT ...
FROM tblA
LEFT OUTER JOIN tblB ON col=col
WHERE tblB.col IS NULL;
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
