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
