1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| SELECT DISTINCT
DOSSIER.date_enre AS date_enre,
DOSSIER.NUM_DOSSIER AS NUM_DOSSIER,
OM.DATE_OM AS DATE_OM,
OM.N_OM AS N_OM,
CLIENT.NOMCLIENT AS NOMCLIENT,
DOSSIER.LIEU AS LIEU,
DOSSIER.DATE_BC AS DATE_BC,
DOSSIER.num_BC AS num_BC,
DOSSIER.obje_demande AS obje_demande,
INSPECTEUR.NOM AS NOM,
OM.DATE_Depart AS DATE_Depart,
OM.Date_retour AS Date_retour,
RAPPORT.NUM_RAPORRT AS NUM_RAPORRT,
RAPPORT.DATE_RECEPTION AS DATE_RECEPTION,
RAPPORT.DATE_REMISE AS DATE_REMISE,
SECRETAIRE.NOM_SEC AS NOM_SEC
FROM
SECRETAIRE,
RAPPORT,
INSPECTEUR,
OM,
DOSSIER,
CLIENT
WHERE
CLIENT.NumClient = OM.NumClient
AND DOSSIER.IDDOSSIER = OM.IDDOSSIER
AND DOSSIER.IDDOSSIER = RAPPORT.IDDOSSIER
AND INSPECTEUR.Reference = OM.Reference
AND INSPECTEUR.Reference = RAPPORT.Reference
AND SECRETAIRE.IDSECRETAIRE = RAPPORT.IDSECRETAIRE
AND OM.Reference = RAPPORT.Reference
AND
(
DOSSIER.date_enre BETWEEN {date1} AND {date2}
) |
Partager