1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT
PLA_NUM AS PLA_NUM,
PLA_LIB AS PLA_LIB,
SUM( CSU_DBT ) AS CSU_DBT,
SUM( CSU_CDT ) AS CSU_CDT
FROM ( SELECT COM_DATE, COM_LIB, PLA_NUM, PLA_LIB, CSU_DBT, CSU_CDT
FROM ( SELECT T_COMPTES.JTY_ID, T_JOURNAUX_TY.JTY_LIB, T_COMPTES.COM_PCE, T_COMPTES.COM_DATE, T_COMPTES.COM_REF, T_COMPTES.COM_LIB, T_PLAN.PLA_NUM, T_PLAN.PLA_LIB, T_COMPTES_SUB.CSU_DBT, T_COMPTES_SUB.CSU_CDT
FROM T_COMPTES_SUB, T_COMPTES, T_JOURNAUX_TY, T_PLAN
WHERE T_COMPTES_SUB.COM_ID = T_COMPTES.COM_ID
AND T_COMPTES.JTY_ID = T_JOURNAUX_TY.JTY_ID
AND T_COMPTES_SUB.PLA_ID = T_PLAN.PLA_ID )
AS R_JOURNAL
GROUP BY COM_DATE, COM_LIB, PLA_NUM, PLA_LIB, CSU_DBT, CSU_CDT )
AS R_GRAND_LIVRE
GROUP BY PLA_NUM, PLA_LIB
ORDER BY PLA_NUM ASC |
Partager