Chris White wrote:
On Monday 07 August 2006 12:13 pm, William DeMasi wrote:
I meant to have it say :
"select * from c2iedm_dev2.act where act_id IN (select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);"
What does the output of (the subselect):
select obj_act_id
from c2iedm_dev2.act_functl_assoc
where subj_act_id =24;
show?
Sorry about that, typo on my part, but I have tried it as above and I get
the error I mentioned.
What version of mysql are you using?
select version();
subselects don't work for versions before v5.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]