The select statement I am trying to run is: "select * from c2iedm_dev2.act where act_id =(select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_act_id =24);"
But I get the error below: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select obj_act_id from c2iedm_dev2.act_functl_assoc where subj_" I have looked at the documentation for MySQL and this seems to be the correct syntax for using "IN". Could someone please let me know what is wrong? Thank you. William DeMasi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]