Brug af flere tabeller i full-text index

Lav en temporær tabel hvor du fylder dine forskellige containstable data ind i:

    --Create temporary result table
    CREATE TABLE #QueryResult (ID int, Rank int)
   
    --perform search on first table and put results in temp table
    INSERT #QueryResult
    SELECT DocumentID, K.Rank
    FROM Document
    INNER JOIN CONTAINSTABLE( Document,*,@searchFor,1000) AS K
    ON Document.DocumentID = K.[KEY]
   
    --perform search on second table and put results in temp table
    INSERT #QueryResult
    SELECT documentID, KWD.RANK
    FROM docKeyword
    INNER JOIN
    (SELECT KeywordID,K.Rank
    FROM Keyword
    INNER JOIN CONTAINSTABLE( Keyword,Keyword,@searchFor,1000) AS K
    ON Keyword.KeywordID = K.[KEY]) AS KWD
    ON docKeyword.KeywordID = KWD.KeywordID
   
    --get all results from temp table
    SELECT Document.DocumentID,Document.FileNam FROM Document
    INNER JOIN
    (SELECT TOP 1000 ID, Max(Rank) as Rank
    FROM #QueryResult
    GROUP BY ID
    ORDER BY Rank DESC) AS Result
    ON Document.Document_nr = Result.ID

        --Drop temporary result table
    DROP TABLE #QueryResult