1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT AS_MSG, AS_DATE, AS_HEURE, AS_NUMEXP, AS_NUMDEST, AS_STATUT, 'E' as AS_MSGES
FROM TABLE_R R WHERE 1=1 AND DATE (R.date) >= '2009-10-01' AND DATE (R.date) <= '2009-10-22'
UNION ALL
SELECT AS_MSG, AS_DATE, AS_HEURE, AS_NUMEXP, AS_NUMDEST, AS_STATUT, 'E' as AS_MSGES
FROM TABLE_R_SAV R WHERE 1=1 AND DATE (R.date) >= '2009-10-01' AND DATE (R.date) <= '2009-10-22'
UNION ALL
SELECT AS_MSG, AS_DATE, AS_HEURE, AS_NUMEXP, AS_NUMDEST, AS_STATUT, 'S' as AS_MSGES
FROM TABLE_D D, TABLE_L L, TABLE_S S WHERE D.ref = L.ref AND S.chmp = L.chmp
AND DATE (L.date) >= '2009-10-01' AND DATE (L.date) <= '2009-10-22'
UNION ALL
SELECT AS_MSG, AS_DATE, AS_HEURE, AS_NUMEXP, AS_NUMDEST, AS_STATUT, 'S' as AS_MSGES
FROM TABLE_D_SAV D, TABLE_L_SAV L, TABLE_S_SAV S WHERE D.ref = L.ref AND S.chmp = L.chmp
AND DATE (L.date) >= '2009-10-01' AND DATE (L.date) <= '2009-10-22' |
Partager