1 2 3 4
|
SQL = "SELECT libel_civilite, nom_part, prenom_part, adresse_part, complement_adresse_part, commune_cp, code_cp, tel_priv_part, tel_portable_part, fax_priv_part, email_part, libel_rang, libel_situationfam, libel_prof, libel_aff, libel_compagnie, libel_mtuelle, libel_situation" & _
"FROM tbl_situationfamilialle INNER JOIN (tbl_situation INNER JOIN (tbl_rang INNER JOIN (tbl_profession INNER JOIN (tbl_mutuelle INNER JOIN (tbl_cp INNER JOIN (tbl_compagnie INNER JOIN (tbl_civilite INNER JOIN (tbl_banque INNER JOIN (tbl_affinite INNER JOIN ((((tbl_particulier INNER JOIN tbl_particulier_affinite ON tbl_particulier.num_part = tbl_particulier_affinite.[num_part#]) INNER JOIN tbl_particulier_banque ON tbl_particulier.num_part = tbl_particulier_banque.[num_part#]) INNER JOIN tbl_particulier_compagnie ON tbl_particulier.num_part = tbl_particulier_compagnie.[num_part#]) INNER JOIN tbl_particulier_mutuelle ON tbl_particulier.num_part = tbl_particulier_mutuelle.[num_part#]) ON tbl_affinite.num_aff = tbl_particulier_affinite.[num_aff#]) ON tbl_banque.num_banque = tbl_particulier_banque.[num_banque#]) ON tbl_civilite.num_civilite = tbl_particulier.[num_civilite#]) ON tbl_compagnie.num_compagnie = tbl_particulier_compagnie.[num_compagnie#]) ON tbl_cp.num_cp = tbl_particulier.[num_cp#]) ON tbl_mutuelle.num_mutuelle = tbl_particulier_mutuelle.[num_mutuelle#]) ON tbl_profession.num_prof = tbl_particulier.[num_prof#]) ON tbl_rang.num_rang = tbl_particulier.[num_rang#]) ON tbl_situation.num_situation = tbl_particulier.[num_situation#]) ON tbl_situationfamilialle.num_situationfam = tbl_particulier.[num_situationfam#]" & _
"WHERE tbl_affinite!num_aff <> 0 " |
Partager