SELECT..FROM..WHERE is about as far as you would need to go in a subquery. e.g.,

SELECT * ;
  FROM table1 ;
  WHERE cfield1 IN ;
  (SELECT cfield2 FROM table2 WHERE lfield = .T.) ;
  INTO CURSOR cutmp

Under the help for the SELECT-SQL command it tells you what can and cannot be put in subqueries.