fulltext indexes aren't working with nested queries

[peerspong pong]

hi,
whats wrong with my sql?

(this is a pure theoretical nonsense example)

the error that i get is:
Can't find FULLTEXT index matching the column list


SELECT *,
MATCH(myfield) AGAINST('key2') AS test2 /* this doesn't work */
FROM
(
SELECT *,
MATCH(myfield) AGAINST('key1') AS test1 /* this works perfectly */
FROM mytable
)
AS nested1

thank you in advance!



Edited 1 time(s). Last edit at 08/28/2012 08:24PM by peerspong pong.