请问这样的嵌套语句还能优化吗
请问这样的嵌套语句还能优化吗,特别是标红的 两张表的数据都比较大 谢谢
SELECT
ROW_NUMBER() OVER(Order by o.orderid ) AS ID,
0 as ReportType,
o.orderid,
pc.realname,
pc.Category,
o.Payamount ,--应收款
o.ThirdPartyFee,
o.orderstatus,
o.ProcessStatus,
o.printtickettime ,--出票日期
o.OrderDate,--订单日期
o.createoid,
o.cid,o.allport,
--(select dbo.Fn_Get_FlightAllPortName(o.orderid)) as AllPortName,
o.isonline,
o.CName,
pc.UserID,
pco.clearingtheway AS BalanceType,
pco.CorpShortName,
o.OrderNumber,
o.RealAcceptDatetime,
o.CollectionTime,
o.RealPayDatetime,
ISNULL(O.backAmount,0) as backAmount,
o.IsInter,
(select count(0) from flt_refund (nolock) where orderid=O.OrderID) as refundCount,
(select count(0) from Flt_ZhiJi with(nolock) where orderid=O.OrderID) as HasZhiJiCount,
(select count(0) from flt_modorder with(nolock) where orderid=O.OrderID and orderstatus not in('w','c','n')) as HasModCount
,(select dbo.Fn_Get_Flt_Order_Profit(O.OrderID)) as OpProfit --员工利润
from flt_order o (nolock)
left join flt_orderunion ou(nolock) on ou.orderid=o.orderid
left join P_customer pc (nolock) on pc.cid=o.cid
left join P_Corporation (nolock) pco on pc.corpid=pco.corpid
left join P_CustomerUnion PCU (nolock) on pc.cid=PCU.cid
left join Flt_Route fr (nolock) on o.routeid=fr.routeid
left join P_Operator PO (nolock)on po.oid=o.createoid
left join Flt_Order_ProjectName PJ (nolock) on PJ.ProjectID=OU.ProjectID
WHERE o.orderstatus not in('N','C') and o.PrintTicketTime>='09 4 2018 12:00AM' and o.PrintTicketTime<='12 4 2018 11:59PM'