select 办公室 from
(select 办公室 from utili t1
inner join ordi t2 on t1.numutil=t2.propretaire
inner join typeordi t3 on t2.numtype=t3.numtype and t3.cate='pc') t1
inner join
(select 办公室 from utili t1
inner join ordi t2 on t1.numutil=t2.propretaire
inner join typeordi t3 on t2.numtype=t3.numtype and t3.cate='mac') t2
on t1.办公室=t2.办公室
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024