Re: [PHP-DB] MYSQL Trouble with the IN operator

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 c

Re: [PHP-DB] MYSQL Trouble with the IN operator

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 > A

[PHP-DB] MYSQL Trouble with the IN operator

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