|
rafael_santos_zenite
Starting Member
Brazil
2 Posts |
 Posted - 06/14/2012 : 15:55:25
|
Hi,
This is my query:
SELECT * FROM TABLE1 AB INNER JOIN TABLE2 AN ON N.id_anotacao_base = AB.id_anotacao_base INNER JOIN CONTAINSTABLE(TABLE1, *, 'word1 NEAR world2... NEAR wordN') AS C ON AB.key = C.[KEY]
This returns me:
"The full-text query has a very complex NEAR clause in the CONTAINS predicate or CONTAINSTABLE function. To ensure that a NEAR clause runs successfully, use only six or fewer terms. Modify the query to simplify the condition by removing prefixes or repeated terms."
There is another solution to put more than six terms, using NEAR? |
Edited by - rafael_santos_zenite on 06/15/2012 07:51:09
|
|
Erro 30052 - Full-text query has a very complex
