Hello all, I'm wanting to do a CONTAINS query on fields that belong to two seperate tables. So, for example, this is what I'd *like* to do : SELECT ci.itemName FROM Content_Items ci INNER JOIN Content_Pages AS cp ON ci.contentItemId = cp.contentItemId INNER JOIN FREETEXTTABLE(Content_Items, ...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Afro Blanca
on
10-30-2007, 12:00 AM
Filed under: SQLServer, sqlserver 2005, views, fulltext, fulltext indexing, FullText Search, indexed views, indexes