SELECT empr_nom as Nom, empr_prenom as Prénom, empr_adr1 as "Adresse (ligne 1)", empr_adr2 as "Adresse (ligne 2)", empr_cp as "Code Postal", empr_ville as Ville, empr_pays as Pays, empr_year as "Année de naissance", empr_pays as Pays, empr_mail as Mail, empr_tel1 as "Téléphone", empr_tel2 as "Autre téléphone", empr_prof as Profession, empr_sexe as Sexe, empr_date_adhesion as "Date adhésion", empr_date_expiration as "Date expiration", empr_msg as Message, type_abt_libelle as "Type d'abonnement" FROM empr join type_abts on type_abt=id_type_abt order by 1,2