尝试执行此操作：



SELECT DI.DynamicIndicatorID，DI。来自DynamicIndicatorsTargetsForPu的Question_ID，DI.Quarter，DI.Year，DI.District，tpl.FileName

AS DI

左外连接tblUploadedFiledetailsForPartners为tpl.DynamicIndicatorID = DI上的tpl。 DynamicIndicatorID

AND tpl.FileId in（从tb中选择max（tb1.FileId） lUploadedFiledetailsForPartners as tb1 where tb1.DynamicIndicatorId = DI.DynamicIndicatorId）



希望这会有所帮助!!

Try executing this:

SELECT DI.DynamicIndicatorID,DI.Question_ID,DI.Quarter,DI.Year,DI.District,tpl.FileName from DynamicIndicatorsTargetsForPu
AS DI
Left Outer Join tblUploadedFiledetailsForPartners as tpl on tpl.DynamicIndicatorID=DI.DynamicIndicatorID
AND tpl.FileId in (select max(tb1.FileId) from tblUploadedFiledetailsForPartners as tb1 where tb1.DynamicIndicatorId = DI.DynamicIndicatorId)

Hope this helps!!