[步骤]

GetDSExecuteSql:SELECT BusinessTeamID as ID,BusinessTeamName AS UserName  FROM RB_Report_OrderSettlement(NOLOCK)  a  inner JOIN (  SELECT MAX(ros.ID) AS ID  FROM RB_Report_OrderSettlement ros WITH (NOLOCK)  WHERE ros.CustomerID = 1        AND BusinessTeamID NOT IN (                                      SELECT ID FROM dbo.RB_BusinessTeam(NOLOCK)                                   )        AND BusinessTeamID > 0  GROUP BY ros.BusinessTeamID) b ON a.ID=b.ID 

[结果]

[期望]

全表查询，建议使用缓存 或者排查是否有 不恰当的循环