select b.* from MGR2_Project p
Cross Apply
(select top(1) * from MGR_WeekReport w where w.ProjId=p.UID and w.Content != '' order by w.ProjId desc,w.Year desc,w.WeekInYear desc)b
Cross Apply OuterApply 弥补left join查询数据冗余问题
select b.* from MGR2_Project p
Cross Apply
(select top(1) * from MGR_WeekReport w where w.ProjId=p.UID and w.Content != '' order by w.ProjId desc,w.Year desc,w.WeekInYear desc)b
Cross Apply OuterApply 弥补left join查询数据冗余问题