Re: [PHP-DB] Query error

[Jeffrey_N_Dyke]

if you are using mysql, it doesn't support the sub-select.



                                                                                       
                                      
                    "Wilmar Perez"                                                     
                                      
                    <[EMAIL PROTECTED]       To:     [EMAIL PROTECTED]         
                                      
                    ea.edu.co>                    cc:                                  
                                      
                                                  Subject:     [PHP-DB] Query error    
                                      
                    10/02/2002 10:54 AM                                                
                                      
                                                                                       
                                      
                                                                                       
                                      




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