SQL server full text indexing, ranking and joinin

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL server full text indexing, ranking and joinin

Author

Topic

ramon6969
Starting Member

11 Posts

Posted - 2010-01-12 : 08:27:38

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
FROM myTable1
JOIN
FreeTextTable(myTable1, [myField1], 'awesome ranking') fulltextSearch
ON
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?

myTable1
----------
id myField1
1 rrrrrrr
2 qqqqqqq
3 kkkkkkk
.
.
.
.

myTable2
-------

id myTable1Foreign
1 4
3 6
2 1
.
.
.

thanks for any inputs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources