问在同一任务中选择其他协作者

EN

SELECT
    t2.Collaborator_ID
FROM collaborative_task t1
INNER JOIN collaborative_task t2
    ON t2.task_ID = t1.task_id    
    AND t2.collaborator_ID <> t1.collaborator_ID
WHERE
    t1.collaborator_id = 14
    AND t2.collaborator_complete = 1
    AND t2.Join_State = 'Accept'

select ct.*
from collaborative_task ct
where collaborator_complete = 1 and join_state = 'Accept' and
      collaborator_id <> 14 and
      exists (select 1
              from collaborative_task ct2
              where ct2.task_id = ct.task_id and
                    ct2.collaborator_id = 14
             );