I think you need to read the page you have refered to again. It specifically says that sub-selects are still scheduled for implementation and the examples given are ways of rewriting subselects to achieve the same result using alternative methods i.e. using joins. The second example on their page does what you are wanting.
-----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 14 May 2002 7:27 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Stupid - I just can't get it (NOT IN or NOT EXISTS) Well that is really dumb because on page: www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html it gives me a manual page oh the syntax of how to use it. However I think you are right and the manual is wrong. (congrats) J >From: Nick Stuart <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]> >Subject: Re: Stupid - I just can't get it (NOT IN or NOT EXISTS) >Date: Mon, 13 May 2002 17:45:59 -0400 (EDT) > >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 > > > _________________________________________________________________ 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
