我会
NOT EXISTS改用：
SELECt t.*FROM [dbo].[FMD15_18] tWHERe NOT EXISTS (SELECt 1 FROM [dbo].[FMD15_18] t1 WHERe t1.OrderNo = t.OrderNo AND t1.[Item Description] Like '%AP%') AND NOT EXISTS (SELECt 1 FROM [dbo].[AP&C] a WHERe a.OrderNo = t.OrderNo);
但是，我怀疑
nullable当前查询存在一些问题。如果是这样，那么您需要配合
IS NOT NULLin
subquery。
