主题：[求助]drawcell中效率太低了 有没有别的办法啊

Select _Identify,OrderNumber,OrderDate,Supplier,InvoiceNumber,InvoiceDate,UserName,Status,

(Select top 1 OrderNumber is null from Purchase_Orders b where (Select Status from Purchase_List where OrderNumber = b.OrderNumber) = '采购中' 

and b.Quantity - (select sum(Quantity) from IQC_Details where Identify = b._Identify) > 0 

And DATEDIFF(day,GETDATE(),b.DeliveryDate) between 0 and 3) as 辅助

from Purchase_List a