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
| SELECT
test.Nom,
test.Prenom,
test.`N°`,
test.Idtitle,
test.Idposition,
test.IdInstitution,
test.IdDepartment,
test.Adresse,
test.ZIP,
test.Idcity,
test.Idcountry,
test.Phone_number,
test.GSM,
test.Fax,
test.Email,
titre.Title,
`position`.Position_en,
pays.Country,
institution.Institution,
departement.Departement,
city.City,
GROUP_CONCAT(language.Langue ORDER BY language.Langue SEPARATOR ';') AS languesParlees
FROM test
INNER JOIN titre ON test.Idtitle = titre.`N°`
INNER JOIN city ON test.Idcity = city.Idcity
INNER JOIN departement ON test.IdDepartment = departement.IdDepartment
INNER JOIN institution ON test.IdInstitution = institution.Idinstit AND departement.Idinstit = institution.Idinstit
INNER JOIN `position` ON test.Idposition = `position`.Idposotion
INNER JOIN pays ON test.Idcountry = pays.Idpays AND institution.idpays = pays.Idpays AND city.Idpays = pays.Idpays
INNER JOIN rel_lang_pers ON test.`N°` = rel_lang_pers.IdPersons
INNER JOIN `language` ON rel_lang_pers.Idlanguage = `language`.`N°`
GROUP BY test.Nom, test.Prenom
ORDER BY test.Nom, test.Prenom; |
Partager