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. -- Chris White PHP Programmer/DBlinds Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]