22,209
社区成员
发帖
与我相关
我的任务
分享
select top 5
[ID],ClassID
from
[News] t
Where
exists(select 1 from 条件表 where ID=t.[ClassID])
Order By
id Desc
select top 5 a.[ID],a.ClassID
from [News] a
join 条件表 b on a.ClassID=b.ID
Order By
id Desc
select top 5
[ID],ClassID
from
[News]
Where
exists(select 1 from 条件表 where ID=t.[ClassID])
Order By
id Desc