In article <9937to$794$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Jen") wrote: > SELECT CONCAT(c.l_name, ", ", c.f_name) name > FROM contractor c > WHERE c.contractor_id NOT IN > (select c.contractor_id > FROM contractor c, task_assign t > WHERE c.contractor_id = t.contractor_id > AND t.task_id=11); > > It throws an error with the NOT IN line. I can replace the NOT IN with NOT > IN(3) giving it a value, and that works. I was under the impression that > you could put a query in the Not in. That's a subquery. MySQL doesn't support subqueries (yet). See the manual. -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]