select * from user left join type_user on type_user.ID=user.type where annuaire='Y' and user.ID=41 order by nom,prenom
Médecin LEFRANC Sandrine
0344517381
Dr LEFRANC Sandrine
130 rue Neuve
60190 La Neuville-Roy
Généraliste
0344517381
Dr LEFRANC Sandrine
0344517381 Dr LEFRANC Sandrine