1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
SELECT
tbl_civilite.libel_civilite,
tbl_particulier.nom_part,
tbl_particulier.prenom_part,
tbl_particulier.email_part,
tbl_particulier.fax_priv_part
FROM
(tbl_cp
INNER JOIN
(tbl_profession
INNER JOIN
(tbl_situationfamilialle
INNER JOIN
(tbl_situation
INNER JOIN
(tbl_civilite
INNER JOIN
tbl_particulier
ON
tbl_civilite.num_civilite = tbl_particulier.[num_civilite#])
ON
tbl_situation.num_situation = tbl_particulier.[num_situation#])
ON
tbl_situationfamilialle.num_situationfam = tbl_particulier.[num_situationfam#])
ON
tbl_profession.num_prof = tbl_particulier.[num_prof#])
ON
tbl_cp.num_cp = tbl_particulier.[num_cp#])
INNER JOIN
(tbl_compagnie
INNER JOIN
tbl_particulier_compagnie
ON
tbl_compagnie.num_compagnie = tbl_particulier_compagnie.[num_compagnie#])
ON
tbl_particulier.num_part = tbl_particulier_compagnie.[num_part#]
WHERE
(((tbl_particulier.num_part)<>0))
GROUP BY
tbl_civilite.libel_civilite,
tbl_particulier.nom_part,
tbl_particulier.prenom_part,
tbl_particulier.email_part,
tbl_particulier.fax_priv_part; |
Partager