[sqlite] Nested SELECT : Alternative syntax please ?

[L�tourneau]

I used to do this kind of SELECT statement in MS Access.  This syntax doesn't 
seem to be understood by SQLite.  Can someone help me find the SQLite syntax 
for doing this ?
   
  SELECT SUM(IntermediateQuery.SomeField)
  FROM (some complex nested SELECT query) AS IntermediateQuery
  GROUP BY IntermediateQuery.SomeOtherField
   
  SQLite complains there is no such field as IntermediateQuery.SomeField...
   
  Any help ?
  Emp