表TUser 与表TUserLog 合并后,出现重复数据,以避免重复数据的方法如下:
Select *,aa.LastTime
From dbo.TUser bb inner join
(
Select MAX(LastTIme) AS LastTime,TUserID,count(ID) AS num
From TUserLog
Group BY TuserID
) as aa
on aa.TUserID= bb.ID
表TUser 与表TUserLog 合并后,出现重复数据,以避免重复数据的方法如下:
Select *,aa.LastTime
From dbo.TUser bb inner join
(
Select MAX(LastTIme) AS LastTime,TUserID,count(ID) AS num
From TUserLog
Group BY TuserID
) as aa
on aa.TUserID= bb.ID