Search Freetext Multiple Columns SQL2000
Posted on 2007-11-29
I am trying to query multiple columns in multiple tables. I need to weigh certain columns in the results. My current code looks as follows:
"select Key_Tbl.[key], tblBlogThreads.BlogThreadNum, tblBlogThreads.Body,tblBlogThreads.PublishDate, tblBlogThreads.Title, tblBlogThreads.Teaser, tblBlogThreads.MetaKeywords, [rank] from freetexttable(tblBlogThreads, body, '" & tstr & "' ) AS Key_Tbl INNER JOIN tblBlogThreads ON tblBlogThreads.BlogthreadID = Key_Tbl.[key] order by [rank] desc"
The problem is i need to search in columns tblBlogThreads.Title, tblBlogThreads, Keywords, and tblBlogThreads.Body, and weigh them in that order.