hello i have query like this
SELECT SUM(apport.poid) AS poid, SUM(apport.quantite) as nb, provenance.provenance, touches.label as label, apport.ladate FROM apport JOIN provenance ON apport.id_provenance = provenance.id_provenance JOIN touches ON apport.id_touches = touches.id_touches WHERE ladate BETWEEN "2014-01-01" AND "2014-12-31" GROUP BY apport.id_touches ORDER BY provenance.provenance, date(apport.ladate), apport.id_touches; in mysql result is sorted like "order by" condition but in sqlite3, the data are only sorted by the fist argumement of "order by" condition removing provenance.provenance order by apport.ladate but not by apport.id_touches any idea? thank Claude _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users