would a "where not in (query here)" clause work? ----- Original Message ----- From: "Christopher Chaduka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 9:35 AM Subject: [ cf-dev ] SQL Brain fuzz
> 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. > > -- > > Christopher Chaduka > Webmaster/Systems Administrator > Technical Department > M-Web Zimbabwe > Tel: +263 4 253333 Fax: +263 4 708055 > Mobile: +263 11 600994 > http://www.mweb.co.zw > > ---------------------------------------------------------------------------- ---- > -- > ** 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
