It would, BUT if you have just spent months developing and debugging a generic SQL compatible application, capable of running on MS SQL, Interbase, Access etc and wanted to port it to MySQL, what would you bother rewriting all your queries and go through all the testing again?
Jeff ----- Original Message ----- From: "Daniel Brockhaus" <[EMAIL PROTECTED]> To: "Jeff Dyer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 4:43 PM Subject: Re: subquery syntax > Wouldn't > > SELECT Contacts.FirstName, Contacts.LastName FROM Contacts, Users WHERE > Users.UserName = 'Doug' AND > Users.UserPassword = 'Crock' AND > Contacts.ContactId = Users.ContactId; > > work? > > Daniel > > At 16:28 30.07.02 +0100, you wrote: > >Forget it (at least for the forseeable future) > > > >This is the well known MySQL feature that means that MySQL is not even SQL > >compatible. Argghhhh. Apparently you will have to wait for version 4.1. > > > >Subqueries are not supported .... > > > >Jeff > > > >----- Original Message ----- > >From: <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Tuesday, July 30, 2002 3:55 PM > >Subject: subquery syntax > > > > > > > Hello: > > > > > > I am new to this and am having trouble with subqueries. > > > > > > Using MySQL 3.23 > > > > > > I have a Contacts table, and a Users table each with a ContactId field. > > > > > > I want to retrieve the ContactID from the Users table where UserName and > > > UserPassword are such and such, I then want to get the FirstName and > > > LastName from the Contacts table with the matching ContactId. > > > > > > The two SELECTS work fine individually and if I manually supply the > > > first SELECT with the result of the SELECT in the subquery, I get the > > > correct result. > > > > > > But I get a syntax error when I combine them. > > > Can anyone suggest where I am fouling up? > > > > > > Here is the query: > > > > > > SELECT Contacts.FirstName, Contacts.LastName FROM Contacts WHERE > > > Contacts.ContactId = (SELECT Users.ContactId FROM Users WHERE > > > Users.UserName = 'Doug' AND Users.UserPassword = 'Crock'); > > > > > > Thanks > > > > > > David > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
