Simple, MySQL doesn't support sub selects. There is a way around this using JOINS but don't know those well enough to describe...anyone else want to give it a shot?
-Nick > 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 <mysql- [EMAIL PROTECTED]> To > unsubscribe, e-mail > <mysql-unsubscribe- [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
