> I have got to tables, tblA and tblB with identical schemas. > tblA has 2 columns, accNum varchar(12) and email varchar(30). > tblA has something like 7000 records, tblB has something > like 13000 records. I need to find records in tblB that are > not in tblA. MySQL 3.23.54.
I'm going on the fact that you want both fields checked, also that accNum can't be NULL SELECT tblB.accNum, tblB.email FROM tblB LEFT OUTER JOIN tblA ON tblB.accNum = tblA.accNum and tblB.email = tblA.email WHERE tblA.accNum is NULL That should work in pretty much all flavours of SQL Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
