Ceci est une ancienne révision du document !
SELECT acc_transactions_users.id_user AS 'Reçu', users.id AS 'idPers', users.nom AS 'Nom', printf('%.2f', SUM(acc_transactions_lines.credit)/100.) AS 'Montant', users.adresse AS 'Adresse', users.code_postal AS 'Code postal', users.ville AS 'Ville' FROM acc_transactions_users, users, acc_transactions INNER JOIN acc_transactions_lines ON acc_transactions_lines.id_transaction = acc_transactions.id WHERE ( strftime('%Y', acc_transactions.date) = strftime('%Y', DATE('now', 'start of year', '-1 year')) AND acc_transactions_lines.credit > 0 AND acc_transactions_users.id_transaction = acc_transactions.id AND acc_transactions_users.id_user = users.id ) GROUP BY acc_transactions_users.id_user ORDER BY users.nom COLLATE NOCASE