nothing wronge with "sql"
the fact seems that foxpro just does not support the complete sql syntax :

select a.thisfld,b.thatfld from (select otherfleds from yalda where .. ) a, malda b where .....


that's possible in oracle,ingres ...