联合查询，查重

select MonthBase.IndicatorID, TypeCode.TypeName from MonthBase inner join TypeCode on MonthBase.TypeID=TypeCode.TypeID where MonthBase.IndicatorID in ('M69')

查重

SELECT     DateString, IndicatorValue, IndicatorID, IndicatorDataTypeID
FROM         IndicatorQuarterBase AS a
WHERE     (IndicatorValue IN
                          (SELECT     IndicatorValue
                            FROM          IndicatorQuarterBase AS IndicatorQuarterBase_1
                            GROUP BY DateString, IndicatorValue
                            HAVING      (COUNT(*) > 1))) AND (DateString IN
                          (SELECT     DateString
                            FROM          IndicatorQuarterBase
                            GROUP BY DateString, IndicatorValue
                            HAVING      (COUNT(*) > 1)))
ORDER BY IndicatorValue, DateString