求一条SQL语句 搞昏了
一张表   就person_ID和project_ID   他们是联合主键
怎么样   根据人员ID   查处他所在project中   的所有人员的ID

------解决方案--------------------
select person_id from table_name where project_id in (
select project_id from table_name where person_id=你给出的值;


)
------解决方案--------------------
有那么晕吗〉赫赫
------解决方案--------------------
select person_id from project where project_id in(select project_id from project where persion_id=值)
------解决方案--------------------
select person_id from project where project_id in(select project_id from project where persion_id=人员ID 值)

------解决方案--------------------
很简单的啊
------解决方案--------------------
是啊不难啊!!!
------解决方案--------------------
select person_id from tablename where project_id =(select project_id from tablename where person_id=***);