>It appears that fox does not support the syntax SELE * FROM (SELE ...).
>
>Am I missing something or do I have to do one query and then the next?
>
Nope - you need to execute the first query prior to executing the second; subqueries are not supported in the FROM clause.