--简化一下：

select
  * 
from
 Sa_PlanSumUpBoardHistory t 
where  
 not exists(select 1 from [Sa_PlanSumUpBoardHistory] where PlanSumUpBoardID=t.PlanSumUpBoardID and EmpID=4)
or
 EmpID=4

------解决方案--------------------
探讨


引用:

SQL code
--简化一下：

select
*
from
Sa_PlanSumUpBoardHistory t
where
not exists(select 1 from [Sa_PlanSumUpBoardHistory] where PlanSumUpBoardID=t.PlanSumUpBoardID and EmpID=4)
o……