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.
| Author |
Topic |
|
chava_sree
Yak Posting Veteran
56 Posts |
 Posted - 2008-07-09 : 20:32:17
|
| Hi,I am using FullText Catalogues which i created for my Search Procedure, where this Catalogue involves 4 tables in a Single FullText Catalogue, and i want to use this one of my Stored Procedure.my question is.DO I NEED TO USE ContainsTable Multiple times as ContainsTable has a Key to Compare while InnerJoining with Another Table i.e., or is there any Better way of doing it.here is my Query where am using FullText Catalogue.******************************************************SELECT Blog.Ownerid, BLOG.blogId, title FROM Blog_Entry BLE INNER JOIN BLOG ON BLOG.BLOGID = BLE.BLOGID INNER JOIN BLOG_TEXT BT ON BT.BLOG_ENTRYID = BLE.BLOG_ENTRYID LEFT OUTER JOIN BLOG_METADATA BM ON BM.BLOGID = BLE.BLOGID INNER JOIN CONTAINSTABLE([BLOG_ENTRY],*,'@ss') AS ftA ON (BLE.BLOGID = ftA.[KEY]) INNER JOIN CONTAINSTABLE([BLOG_TEXT],*,'@ss') AS ftB ON (BT.BLOG_ENTRYID = ftB.[KEY]) LEFT OUTER JOIN CONTAINSTABLE([BLOG_METADATA],*,'@ss') AS ftC ON (BM.BLOGID = ftC.[KEY])******************************************************Appreciate your help.Thanks |
|
|
|
|
|
ContainsTable on Multiple Tables