Hi, I guess what you're trying to do is a kind of Sub-select....not yet supported by MySQL (see http://www.mysql.org/products for exact version : I guess it is supposed to be done in 4.1, but not sure!)
However, for example, you can rewrite this query : SELECT * FROM table1 WHERE id IN (SELECT id FROM table2); by writing this : SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id; Hope it helps.. Cheers. Xavier Xavier Prélat CTO Webcenbtric 25 rue de Ponthieu 75008 PARIS -----Message d'origine----- De : Guillaume BABIK [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 22 février 2002 12:47 À : [EMAIL PROTECTED] Objet : Question about SQL... Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me.. Thks a lot.. BABIK Guillaume Développeur Web [ http://www.absolut.fr/ ]ABSOLUT Reality --------------------------------------------------------------------- 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