I am using FREETEXTTABLE, however, when I try to do the inner join, the result is empty, showing me nothing at the end, although it does not make me an error either, it simply marks everything as empty.
SELECT * FROM FREETEXTTABLE(dbo.tabla1,*,'algo') AS T INNER JOIN
dbo.tabla2 AS U ON T.[KEY] = U.id;
I have the suspicion that it is in the FULL TEXT INDEX but I would like to receive your advice before moving anything else, if you need more information please tell me