If it's on MySQL, then the problem is that it doesn't support nested queries :)
If it's on something else, i'm afraid i don't know :/ Back to MySQL, you can get around that by doing your "select author_code from authorxcat" component query, then put the results into 'x', 'y', 'z' format, then do something like "select author_code from author where author_code not in ($previousResults)" HTH Beau // -----Original Message----- // From: Wilmar Perez [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 2 October 2002 10:54 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Query error // // // Hello guys // // Does anybody have a clue on what wrong with the following sentence? // // select author_code from author where author_code not in // (select author_code from authorxcat); // // Thanks // // ******************************************************* // Wilmar Pérez // Network Administrator // Library System // Tel: ++57(4)2105145 // University of Antioquia // Medellín - Colombia // 2002 // ******************************************************* // // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
