1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
SELECT N°, MVT_DATE, MVT_JNL, MVT_GEN, MVT_PAR, MVT_ACT, RTRIM(MVT_LIB)As MLIB,
IIf(MVT_MNT <0, Abs(MVT_MNT) ,Null) As DEBIT, IIf(MVT_MNT > 0, MVT_MNT ,Null)As CREDIT,
IIF(N° IN (SELECT N° FROM D_MODMVT),1,0)As STATE
FROM D_MVT WHERE (D_MVT.N° = :ecr1 )
UNION ALL
SELECT N°, MVT_DATE, MVT_JNL, MVT_GEN, MVT_PAR, MVT_ACT, RTRIM(MVT_LIB)As MLIB,
IIf(MVT_MNT <0, Abs(MVT_MNT) ,Null) As DEBIT, IIf(MVT_MNT > 0, MVT_MNT ,Null)As CREDIT, 2 As STATE
FROM D_MODMVT WHERE (D_MODMVT.N° = :ecr2 )
UNION ALL
SELECT N°, MVT_DATE, MVT_JNL, MVT_GEN, MVT_PAR, MVT_ACT, RTRIM(MVT_LIB)As MLIB,
IIf(MVT_MNT <0, Abs(MVT_MNT) ,Null) As DEBIT, IIf(MVT_MNT > 0, MVT_MNT ,Null)As CREDIT, 3 As STATE
FROM D_SUPMVT WHERE (D_SUPMVT.N° = :ecr3 )
ORDER BY 1 ; |
Partager