1 2
| SELECT public_client_coordonnees1.code_client, public_client_coordonnees1.id_client_coordonnees, public_client_coordonnees1.nom, public_cde1.id_cde, public_cde1.totalht, public_cde1.delais, public_divers_cde1.docslist_div01 AS [Etat Z], public_divers_cde1.docslist_div02 AS [Date état Z], public_divers_cde1.docslist_div03 AS [Etat L], public_divers_cde1.docslist_div04 AS [Date Etat L], public_divers_cde1.docslist_div05 AS [Etat P], public_divers_cde1.docslist_div06 AS [Date Etat P], public_divers_cde1.docslist_div07 AS [Etat M], public_divers_cde1.docslist_div08 AS [Date Etat M], public_divers_cde1.docslist_div10 AS [Date Cde Profilé ALU], public_divers_cde1.docslist_div11 AS [Lot Atelier N°], public_divers_cde1.docslist_div09 AS [Date SAV]
FROM (public_client_coordonnees1 INNER JOIN public_cde1 ON public_client_coordonnees1.id_client_coordonnees = public_cde1.client_coordonnees_id) LEFT JOIN public_divers_cde1 ON public_cde1.id_cde = public_divers_cde1.cde_id; |
Partager