合并相同id
SELECT a.fldWordID, a.fldWordName, b.fldID, dbo.tblArticles.fldArticleTitle,
dbo.tblArticles.fldArticleID
FROM dbo.tblKeyWords a INNER JOIN
dbo.tblArticleWords b ON a.fldWordID = b.fldWordID INNER JOIN
dbo.tblArticles ON b.fldArticleID = dbo.tblArticles.fldArticleID
WHERE (a.fldWordName LIKE '%网% ')
结果如下:
147 网通损失 405 网通损失90万元话费 203
153 网站导航 439 网站内部链接优化有哪些? 210
155 网站地图 441 网站内部链接优化有哪些? 210
请问有没有办法合并 id为210的记录
------解决方案--------------------up