1 2 3 4 5 6 7 8 9 10 11
|
SELECT no_adherent, abreviation, nom, prenom, categorie, etat, type,
adresse1, v1.codepostal AS codepostal1, v1.ville AS ville1,
adresse2, v2.codepostal AS codepostal2, v2.ville AS ville2,
telephone1, telephone2, sexe, date_pr_i
FROM adherent, type_adherent, ville_adherent v1, ville_adherent v2, civilite
WHERE no_adherent='" + this.indexLecteur + "'
AND adherent.id_type = type_adherent.id
AND adherent.id_ville = v1.id
AND adherent.id_ville2 = v2.id
AND adherent.id_civilite = civilite.id |
Partager