1.你有两个表要有关联才行
2。like 后面应该是一字符串SELECT COUNT(*) FROM Topic a, News_Train a WHERE a.id=b.id and News_Train.Topic LIKE '%ABC%'
2。like 后面应该是一字符串SELECT COUNT(*) FROM Topic a, News_Train a WHERE a.id=b.id and News_Train.Topic LIKE '%ABC%'
FROM Topic
, News_Train
WHERE News_Train.Topic LIKE '%'+ltrim(rtrim(Topic.Topic))+'%'
FROM Topic
, News_Train
WHERE UPPER(News_Train.Topic) LIKE '%'+UPPER(ltrim(rtrim(Topic.Topic)))+'%'