could you use cf to query both tables, copy all the results to a fake query, and then query that with distinct? I'm sure you'll be able to with query of queries.
then you could insert that into a 3rd table or something? ----- Original Message ----- From: "Christopher Chaduka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 9:48 AM Subject: Re: [ cf-dev ] SQL Brain fuzz > MySQL 3.23.54 doesn't support sub-selects, as far as I understand it. > > At 09:37 03/05/2003 +0000, you wrote: > > >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] > > ---------------------------------------------------------------------------- ---- > -- > ** 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]
