SELECT * FROM user_table AS A INNER JOIN freetextTABLE (user_table, *, '"&gjz&"') AS B ON A.ID = B.[KEY] where Audit=2 order by A.Set_top desc,B.RANK desc,A.Advances desc,A.id desc

当我查询 IBM笔记本  如图!