SELECT
'OSGT' AS SERVEUR, 'DI01' AS BDD, pa.CODEPARCMATL,
pa.NUMPARCMATL, pa.LIBEPARCMATL, ty.LIBEMATL AS LIBEMATM,
ve.LIBTYPEVEHI, co.LIBECONDITIONNEMENT_FR, fa.LIBFAMMATL, ton.LIBTONNAGE, coll.LIBECOLLECTE,
CONVERT(VARCHAR(10), CONVERT(DATETIME, pa.DATEMSENSERV), 103) AS DATEMSENSERV,
se.DATEDEPOT AS DATEDEPOT,
CONVERT(VARCHAR(10), CONVERT(DATETIME, se.DATERETRAIT), 103) AS DATERETRAIT,
se.NOTES, se.NOTEAGENTPLAN AS NOTESAGENTPLAN, li.CODELIEUEXPL,
li.LIBELIEUEXPL AS LBELIEUEXPL, li.ADRE1LIEUEXPL AS ADR1LIEUEXPL,
li.ADRE2LIEUEXPL AS ADR2LIEUEXPL, li.CODECP_CP AS CPLIEUEXPL,
ag.NOMAGEN, cl.CODECLIE, cl.CODECLIEU, cl.NOMCLIE, cl.ADRE1CLIE,
cl.ADRE2CLIE, cl.CODECP_CP
FROM dbo.PARCMATL pa LEFT OUTER JOIN
dbo.TYPEMATL ty ON pa.CODETYPEMATL_TYPEMATL = ty.CODETYPEMATL LEFT OUTER JOIN
dbo.SERVICE se ON pa.CODEPARCMATL = se.CODEPARCMATL_PARCMATL LEFT OUTER JOIN
dbo.AGEN ag ON se.CODEAGEN_AGEN = ag.CODEAGEN LEFT OUTER JOIN
dbo.LIEUEXPL li ON se.CODELIEUEXPL_LIEUEXPL = li.CODELIEUEXPL
LEFT OUTER JOIN
dbo.CLIE cl ON cl.CODECLIE = se.CODECLIE_CLIE LEFT OUTER JOIN
dbo.TYPEVEHI ve ON ty.CODETYPEVEHI_TYPEVEHI = ve.CODETYPEVEHI
LEFT OUTER JOIN
dbo.CONDITIONNEMENT co ON ty.CODECONDITIONNEMENT_CONDITIONNEMENT = co.CODECONDITIONNEMENT LEFT OUTER JOIN
dbo.FAMMATL fa ON ty.CODEFAMMATL_FAMMATL = fa.CODEFAMMATL
LEFT OUTER JOIN
dbo.TONNAGE ton ON ty.CODETONNAGE_TONNAGE = ton.CODETONNAGE LEFT OUTER JOIN
dbo.COLLECTE coll ON ty.CODECOLLECTE_COLLECTE = coll.CODECOLLECTE
WHERE (ag.NOMAGEN IS NOT NULL)
Partager