27,579
社区成员
发帖
与我相关
我的任务
分享
select m.title, m.content, m.crtdate, n.keyword, n.holdday,
priority = case when datediff(day, getdate(), n.CRTDATE) > n.holdday then '' else n.priority end
from
(select * from table2) m
cross apply
(
select top(1) *
from table1 a
inner join table2 b
on b.title like '%'+a.keyword+'%' or b.content like '%'+a.keyword+'%'
where b.title = m.title and b.content = m.coneten and b.crtdate = m.crtdate
order by a.priority
) n
select * from table2 a left join table1 b
on charindex(a.KEYWORD,b.TITLE )>0
order by a.CRTDATE-getdate()