So, you didn't like my SQL then??? 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. ********************************************************************** > -----Original Message----- > From: Christopher Chaduka [mailto:[EMAIL PROTECTED] > Sent: 05 March 2003 12:55 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] SQL Brain fuzz > > > *sigh* I thought there was a simple SQL statement I could use. > > Thanx, and bummer, have to do this with PHP. :( > > At 09:52 03/05/2003 +0000, you wrote: > > >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] > > -- ** 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]
