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 37
| select
dct.DATE_REPLICATION,
dct.DCT_DETCOM
,dct.DCT_FACTURE
,dct.DCT_VERSIONCONTRAT
,dct.DCT_NUMEROCONTRAT
,dct.DCT_DATEEDITCONTRAT
,dct.DCT_DATEDEBUT
,dct.DCT_DATEFIN
,dct.DCT_NBPAX
,dct.DCT_DATACONTRAT
,dct.DCT_CONTRAT
,dct.DCT_EDITIONS
,dct.DCT_DATE
,dct.DCT_MNT_COM_ENREG
,dct.DCT_EST_IMPRIMEE_VERSION
,dct.DCT_DATEEDIT_PREMIER
,dct.DCT_DATEEDIT_PRECEDENT
,dct.BRS_ID
,dct.AGE_CODE_MODIF
,dct.AGT_CODE_MODIF
, dct.EVENT_TYPE
from g4nfprod.DETCOMTO_REPLICATION dct
JOIN (
SELECT dctdate.DCT_DETCOM
,dctdate.DCT_FACTURE
,dctdate.DCT_VERSIONCONTRAT
, MAX(dctdate.DATE_REPLICATION) AS MAX_DATE
FROM g4nfprod.DETCOMTO_REPLICATION dctdate
group by dctdate.DCT_DETCOM
,dctdate.DCT_FACTURE
,dctdate.DCT_VERSIONCONTRAT
) alldate
ON alldate.DCT_DETCOM = dct.DCT_DETCOM
AND alldate.DCT_FACTURE = dct.DCT_FACTURE
AND alldate.DCT_VERSIONCONTRAT = dct.DCT_VERSIONCONTRAT
AND alldate.MAX_DATE = dct.DATE_REPLICATION |
Partager