select iiald.I_W xxx ,iiald.I_LW xxxx, iiald.D_T xxx,iiald.I_N xxx ,iiald.ETime xxxx, count (tif.T_Speeding) xxx from (select ijd.ID, iiai.I_W,iiai.I_LW,iiai.D_T ,iiai.I_N ,ijd.STime,ijd.ETime from (select ii.I_ID,ii.I_W,ii.I_LW, ai.D_T,ii.I_N ,ai.D_ID FROM NormalInfo.dbo.InstrumentInfo ii left join NormalInfo.dbo.ActualInfo ai on ii.I_ID=ai.I_ID where ii.R_ID=5) iiai left join InjuryInfo.dbo.InjuryDetails ijd on iiai.D_ID=ijd.DID ) iiald left join InjuryInfo.dbo.TaskInfo tif on iiald.ID=tif.IID group by iiald.I_W ,iiald.I_LW , iiald.D_T ,iiald.I_N ,iiald.ETime , tif.T_Speeding
自己实现的多左连接 和 group by 使用同服务器多库链接
最新推荐文章于 2022-10-24 19:06:34 发布