Re: [PHP] MySQL NOT IN Query not working

2006-03-16 Thread Miles Thompson
At 08:41 PM 3/16/2006, Kevin Murphy wrote: Anyone want to point me to why this isn't working: $hr_query = select dp_lname,dp_fname,dp_id FROM dir_all WHERE dp_id NOT IN (SELECT sup_id FROM dir_title2) ORDER BY dp_lname;

Re: [PHP] MySQL NOT IN Query not working

2006-03-16 Thread Ligaya Turmelle
Kevin Murphy wrote: Anyone want to point me to why this isn't working: $hr_query = select dp_lname,dp_fname,dp_id FROM dir_all WHERE dp_id NOT IN (SELECT sup_id FROM dir_title2) ORDER BY dp_lname; There are two tables, dir_all (the main list of everyone) and

Re: [PHP] MySQL NOT IN Query not working

2006-03-16 Thread Kevin Murphy
Yup. Thats the problem. I'm running 4.0.21. Thanks. -- Kevin Murphy Webmaster - Information and Marketing Services Western Nevada Community College www.wncc.edu (775) 445-3326 On Mar 16, 2006, at 4:48 PM, Miles Thompson wrote: At 08:41 PM 3/16/2006, Kevin Murphy wrote: Anyone want to