Chris wrote:
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_
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 c2
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_
On Monday 07 August 2006 12:02 pm, William DeMasi wrote:
> 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);"
Well the problem I'm seeing is that you're not using IN anywhere in
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 f
