1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT M1.COBC, M1.EMT, EMPLOYE.NOMEMP, M1.DATEBC, M1.COFOU, FOURNISS.NOM, M1.OBS, ECHEANCFOUR.ECHEANCE,STRING_AGG(WL.DateVersChaîne(M1.DELAI),' + ')
FROM
(
SELECT D2.DELAI, D2.COBC, B2.DATEBC, B2.COBC,B2.EMT,B2.COFOU,B2.OBS
FROM DETAILBC D2 INNER JOIN BC B2 ON D2.COBC = B2.COBC
WHERE B2.DATEBC = '20160825'
GROUP BY D2.DELAI, D2.COBC, B2.DATEBC, B2.COBC,B2.EMT,B2.COFOU,B2.OBS
) M1
LEFT JOIN ECHEANCFOUR ON M1.COBC = ECHEANCFOUR.COBC
LEFT JOIN EMPLOYE ON M1.EMT = EMPLOYE.CODEEMP
LEFT JOIN FOURNISS ON M1.COFOU = FOURNISS.COFOU
GROUP BY M1.COBC, M1.EMT, EMPLOYE.NOMEMP, M1.DATEBC, M1.COFOU, FOURNISS.NOM, M1.OBS, ECHEANCFOUR.ECHEANCE |
Partager