Re: [sqlite] problem sorting data

2014-06-18 Thread Igor Tandetnik
On 6/18/2014 12:19 PM, claude.pom...@free.fr wrote: 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

[sqlite] problem sorting data

2014-06-18 Thread claude . pomalo
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