Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Baron Schwartz (baronxaprb.com)
Date: Fri Oct 26 2007 - 10:42:12 CDT
Aaron Fischer wrote:
> 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:"
LEFT OUTER JOIN tblB ON col=col
WHERE tblB.col IS NULL;
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql