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