Union of two full text queries without duplicates
By Bill Graziano
on 23 October 2000
| 1 Comment
| Tags: SELECT
David writes "Hi SQL Guru, I am trying to union two queries into one result set using union. Both queries are full text searches using ContainsTable on different tables in the same database. There is one full text catalog shared by both tables. My problem is that I am getting rows that are duplicates in all columns except FullTextTable.Rank . . .