Select '是在同一部门' where exists
(Select Dept_ID from 表 where staff_Name = '员工乙' and Dept_ID in (Select Dept_ID from 表 where staff_Name = '员工甲') )
(Select Dept_ID from 表 where staff_Name = '员工乙' and Dept_ID in (Select Dept_ID from 表 where staff_Name = '员工甲') )
select '在'
(select 1 from [table] t ,[table ] t2
where t.Staff_Name in ('员工甲','员工乙') and t2.Staff_Name in ('员工甲','员工乙') and t.dept_id=t2.dept_id and t.Staff_Name<>t2.Staff_Name ) then '在同一部门' else
'不在同一部门' end
今天怎么写得这么复杂?回去睡觉
from(select dept_id from 表 where staff_name='员工甲') a left join(select dept_id from 表 where staff_name='员工乙') b on a.dept_id=b.dept_id