1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| select compte as id_compte, Rest as montant, position from salaire
union all
select compte as id_compte, Budget as montant, position from salaire
union all
select compte as id_compte, Depenses as montant, position from salaire
union all
select compte as id_compte, Budget as montant, position from materiel
union all
select compte as id_compte, Depenses as montant, position from materiel
union all
select compte as id_compte, Rest as montant, position from materiel
union all
select compte as id_compte, Budget as montant, position from investissement
UNION ALL
select compte as id_compte, Depenses as montant, position from investissement
UNION ALL
select compte as id_compte, Rest as montant, position from investissement
UNION ALL
select compte as id_compte, Budget as montant, position from compensation
UNION ALL
select compte as id_compte, Depenses as montant, position from compensation
UNION ALL
select compte as id_compte, Rest as montant, position from compensation
ORDER BY id_compte; |
Partager