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, public_divers_cde1.docslist_div02, public_divers_cde1.docslist_div03, public_divers_cde1.docslist_div04, public_divers_cde1.docslist_div05, public_divers_cde1.docslist_div06
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; |