SELECT * FROM
(SELECT
--t.ID,
t.BigClass,
t.Num,
t.SmallClass,
t.[Content],
t.IsQuantization,
--t.DeptId,
--t.TargetValue,
--t.MinValue,
--t.StriveValue,
--t.Score,
--t.BelongToPeriod,
--t.QuantizationType,
--t.IndicatorSepDept,
--t.F_CreateDate,
--t.[Status]
dzir.*
,row=ROW_NUMBER() OVER(PARTITION BY t.ID ORDER BY dzir.CreateTime desc)
FROM
DK_ZB_DeptIndicator AS t
RIGHT JOIN
DK_ZB_IndicatorReport AS dzir ON dzir.IndicatorsID = t.ID) AS t WHERE t.row = 1
DK_ZB_DeptIndicator 对应你的 user 表
DK_ZB_IndicatorReport 对应你的 作品表