1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
SELECT T3.LIBELLE, T1.NFACTURE AS NUMERO, T2.DATE_PAIEMENT, T1.DATE_DEBUT, T1.DATE_FIN, T2.PUBLIE, T3.TYPE_ABO
FROM TABLE1 T1, TABLE2 T2, TABLE3 T3, TABLE4 T4
WHERE T1.REFI=T3.REFI
AND T1.NFACTURE=T2.NFACTURE
AND T1.APPLICATION='APPLI'
AND T3.TYPE_ABO=1
AND T2.STATUS_PAIEMENT=0
AND (T4.ID=502 AND T1.USERID=T4.USERID)
UNION ALL
SELECT T3.LIBELLE, 0 AS NUMERO, T1.DATE_DEBUT AS DATE_PAIEMENT, T1.DATE_DEBUT, T1.DATE_FIN, 1 AS PUBLIE, T3.TYPE_ABO
FROM TABLE1 T1, TABLE3 T3, TABLE4 T4
WHERE T1.REFI=T3.REFI
AND T1.APPLICATION='APPLI'
AND (T3.TYPE_ABO=2 OR T3.TYPE_ABO=5)
AND (T4.ID=502 AND T1.USERID=T4.USERID) |
Partager