--和#A表连接获取UserName,根据#C表各Mobile和#A表各UserName的HasTime的和,按时间和降序排列 --连接后表中UserName为NULL的将其默认设置为“匿名用户” SELECT #C.Mobile,ISNULL(UserName,'匿名用户') AS UserName,SUM(HasTime) AS SumTime FROM #C LEFTJOIN #A ON #C.UserId=#A.UserId GROUPBY #C.Mobile,#A.UserName ORDERBY SumTime DESC