You are right in thinking that 3.23.54 doesn't support subqueries , MySQL Server 4.0 lays the foundation for the new features of MySQL Server 4.1 and onward, such as nested subqueries stored procedures (5.0) ,and foreign key integrity rules for MyISAM tables dates for these are still pending as both are still in development and 5.0 is a looooong way off
MySQL 4.0 -- Gamma release MySQL 4.1 -- Alpha release - Paul ----- 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] -- ** 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]
