1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT
SituCalcPape.TYPE_LETTRAGE AS TYPE_LETTRAGE,
SituCalcPape.DEBIT AS DEBIT,
SituCalcPape.CREDIT AS CREDIT,
SituCalcPape.Num_Ecriture AS Num_Ecriture,
SituCalcPape.ThemeCalc AS ThemeCalc,
SituCalcPape.DATeLettrage AS DATeLettrage,
SituCalcPape.LETTRAGE AS LETTRAGE
FROM
SituCalcPape
WHERE
(
SituCalcPape.DATeLettrage BETWEEN {ParamDat1} AND {ParamDat2}
OR SituCalcPape.DATeLettrage BETWEEN {ParamDat3} AND {ParamDat4}
OR SituCalcPape.DATeLettrage BETWEEN {ParamDat5} AND {ParamDat6}
OR SituCalcPape.DATeLettrage BETWEEN {ParamDat7} AND {ParamDat8}
)
AND SituCalcPape.TYPE_LETTRAGE = {ParamTypLettrag}
AND SituCalcPape.ThemeCalc = {ParamThemCalc} |
Partager