i searched the net about sql server full text indexing and ranking and got this sample sql statement and it works using 1 table only:
SELECT myTable1.id, myTable1.Title, fulltextSearch.Rank
FreeTextTable(myTable1, [myField1], ‘awesome ranking’) fulltextSearch
myTable1.id = fulltextSearch.[KEY]
ORDER BY Rank DESC
what i do not know is how to make it to work when it is joined to another table. how do i do that if i have these sample tables?