MySQL doesn't support Sub-Selects yet... http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan -----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 4:49 PM To: [EMAIL PROTECTED] Subject: Stupid - I just can't get it (NOT IN or NOT EXISTS) Simle query request: I want to display the ID for everyone in a table who is NOT in a second table. so this is what I have come up with SELECT student.SID, student.firstName FROM student WHERE student.SID NOT IN (SELECT msoccerroster.SID FROM msoccerroster) It comes up with an error 1064: SQL syntax near '(SELECT msoccerroster.SID FROM msoccerroster)' please help J _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com --------------------------------------------------------------------- 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
