select * from RptDataObjRefTbl rd left join RptComprehensiveTbl rc on (rd.Id=rc.ObjRefID and rc.Flag=20 and rc.CheckYear=@years and rc.CheckMonth=@months) where rd.ReportType=@reportType and rd.SonGrade<>'' and rd.Flag=20 order by rd.Ord desc,rd.SonGrade;
select * from RptDataObjRefTbl rd left join Rpt