I need to sum amounts and return keys where other fields are the same on an in-memory database.
I have my own unique key uniqDna, fields cname and cadr, and numeric field due I want to SUM(due) for each unique cname||cadr, and get get the corresponding keys. DISTINCT ON would due this, but it's not supported by SQLite. At the moment, I'm not seeing any approach other than returning them all, and using cname||cadr as a matrix key, and summing myself. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode