FreeTextTable & ContainsTable queries for joining two tables

  • Hi,

    How can i join two tables data in a FreeTextTable & ContainsTable, Can anybody give me examples how can i do multiple search using FreeTextTable & ContainsTable from different tables in the database

  • What do those two tables have in common?

    E.g. considering the same key exists in both tables:

    select<column list>

    from<table 1>

    inner joincontainstable(<arguments> ) t1ct

    ont1ct. = <table 1>.<FTS key column>

    <inner or outer> join<table 2>

    on<table 2>.<common key> = <table 1>.<common key>

    inner joinfreetexttable(<arguments> ) t2ft

    ont2ft. = <table 2>.<FTS key column>

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply