sql server freetexttable in unrelated multiple tables

Question

如何在不相关的多个表中使用freetexttable？下面是我为单个表构建的查询。

 SELECT XXXX,XXXX,XXXX,XXXX 
 FROM table1 INNER JOIN 
 FREETEXTTABLE(table1, (XXXX, XXXX, XXXX),'Search Keyword') AS f 
 ON table1.ID= f.[key] 
 WHERE f.rank > 0 
 ORDER BY table1.Date desc  ;

我想搜索多个不相关的表，并根据排名、最新日期返回最佳匹配结果集。我如何实现这一点？

Answer 1

我认为这就是您要做的：

 SELECT [Date]
      , [Rank]
      , XXXX
      , XXXX
 FROM   table1
        INNER JOIN FREETEXTTABLE(table1, ( XXXX, XXXX, XXXX ), 'Search Keyword')
        AS f ON table1.ID = f.[key]
 WHERE  f.rank > 0
 UNION ALL
 SELECT [Date]
      , [Rank]
      , XXXX
      , XXXX
 FROM   table2
        INNER JOIN FREETEXTTABLE(table2, ( XXXX, XXXX, XXXX ), 'Search Keyword')
        AS f ON table1.ID = f.[key]
 WHERE  f.rank > 0
 ORDER BY [RANK]
      , [Date] DESC;