Fulltext predicate references columns from two different tables or indexed views SELECT dbo . CustomerMap . DisplayCategoryId , dbo . Customer . CompanyName , dbo . Customer . website , dbo . CustomerMap . Description , dbo . Country . Country , dbo . Customer . phoneNo , dbo . Customer . Mobile , dbo . Customer . FaxNo , dbo . Customer . Address , dbo . Customer . AboutUsUrl , dbo . Customer . ProductUrl , dbo . Customer . EnqiryUrl , dbo . Customer . email FROM dbo . CustomerMap INNER JOIN dbo . Customer ON dbo . CustomerMap . CustomerId = dbo . Customer . CustomerCode INNER JOIN dbo . Country ON dbo . Customer . Country = dbo . Country . Id where freetext (( CompanyName , Description ), @CODE ) gives the following error. Msg 7646, Level 16, State 1, Procedure sp_readALLCustomerBySearch, Line 11 Fulltext predicate references