34,590
社区成员
发帖
与我相关
我的任务
分享
--就是每个用戶啊,UserId不就是用戶麼
select a.*,
b.*
from [User] a,Atical b
where a.id=b.UserId
and not exists(select 1 from Atical where UserId=b.UserId and EntryTime>b.EntryTime)
select a.*,
b.*
from [User] a,Atical b
where a.id=b.UserId
and not exists(select 1 from Atical where UserId=b.UserId and EntryTime>t.EntryTime)