No the manual is right and Nick is right too. I think you need to take your reading skills to a next level before cursing at the manual. If you read the manual carefully, you would see that the manual first gives the sub-select queries which MySQL is yet to support and then gives an alternative statement to subsitute it. Quoted from the manual is: " SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);
This can be rewritten as: SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id; .... " Gurhan -----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 5:57 PM 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
