CONTAINSTABLE/ fullt文本搜索

Question

SELECT DISTINCT CP.* FROM ContentPack CP
    INNER JOIN [Content] C ON CP.ContentPackId = C.ContentPackId

 INNER JOIN
     CONTAINSTABLE([Content],Title, [Description],
                    'How can I make my own beers and ales') AS KEY_TBL
     ON C.Title = KEY_TBL.[KEY]

在这里，我尝试对表内容进行搜索，并从ContentPack表中返回与搜索匹配的记录

但是我不能把它放在CONTAINSTABLE的正确语法中

Answer 1

试试这个：

SELECT DISTINCT CP.* FROM ContentPack CP
    INNER JOIN [Content] C ON CP.ContentPackId = C.ContentPackId

 INNER JOIN
     CONTAINSTABLE([Content], (Title, [Description]),
                    'How can I make my own beers and ales') AS KEY_TBL
     ON C.Title = KEY_TBL.[KEY]