MySQL doesn't support nested selects.
At 04:13 PM 3/18/01 -0500, Jen wrote:
>Could someone please give their insight?
>I'm having trouble with this query...
>
>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. Can someone please make a sugestion as
>to how this could be done without the NOT IN operator?
>
>Help is GREATLY appreciated!!
> Jen
>
>
>
>
>
>
>
>--
>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]
##########################################################
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##########################################################
--
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]