I think this is a subselect and not supported yet - read on
subselects in the manual; I did a search and here we are:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
Lindsay G Mccracken schrieb am Freitag, 24. August 2001, 15:02:11:
>>Date: Thu, 23 Aug 2001 17:39:14 +0100
>>To: [EMAIL PROTECTED]
>>From: Lindsay G Mccracken <[EMAIL PROTECTED]>
>>
>> Trying to do a set difference,
>>select * from staff where NOT IN (select * from Supervises where Role='0' );
>>Can't seem to get it to work, is there a different way of doing this in
>>mqsql??
> Can't seem to find in the documentation
>>Thanks
> ---------------------------------------------------------------------
> 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
Herzlich
Werner
--
MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Dr. Werner Stürenburg <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant
/_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany
<___/ www.mysql.com +49-5224-997-407 Fax -409
---------------------------------------------------------------------
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
