Access isn't very compatible with anything else ;) why is the outer select wrapped around the inner query? why not just put the group by on the inner query?
SELECT SUM(SomeField) FROM complex query tables here GROUP BY SomeOtherField On 4/8/07, Yannick Létourneau <[EMAIL PROTECTED]> wrote:
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
-- -- The PixAddixImage Collector suite: http://groups-beta.google.com/group/pixaddix SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
