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]

Reply via email to