- 'SELECT *, strftime(\'%s\', date) AS date FROM (
- SELECT * FROM compta_journal WHERE compte_debit = :compte AND id_exercice = '.(int)$exercice.'
- UNION
- SELECT * FROM compta_journal WHERE compte_credit = :compte AND id_exercice = '.(int)$exercice.'
- )
- ORDER BY date, numero_piece, id;', SQLITE3_ASSOC, ['compte' => $compte]);
+ 'SELECT *, strftime(\'%s\', date) AS date FROM compta_journal
+ LEFT JOIN compta_flux ON compta_journal.id = compta_flux.id_journal
+ WHERE compte = :compte AND id_exercice = '.(int)$exercice.'
+ ORDER BY date, numero_piece, id;', SQLITE3_ASSOC, ['compte' => $compte]);