1. CREATE TABLE CENTRES (
2.   numcentre TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
3.   numgerantsite MEDIUMINT UNSIGNED NOT NULL,
4.   numresponsablesite MEDIUMINT UNSIGNED NOT NULL,
5.   numsuiviadmifinance MEDIUMINT UNSIGNED NOT NULL,
6.   numresponsablepeda MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
7.   PRIMARY KEY(numcentre)
8. );
10. Exemple de valeur de la table
11. umcentre => 15
12. numgerantsite => 31
13. numresponsablesite => 37
14. numsuiviadmifinance => 41
15. numresponsablepeda => 23
17. CREATE TABLE GENS (
18.   numgens MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
19.   titregens ENUM('M','Mme','Me','Dr','Pr') NOT NULL,
20.   nomgens VARCHAR(50) NOT NULL,
21.   prenomgens VARCHAR(50) NOT NULL,
22.   PRIMARY KEY(numgens)
23. );

1. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numgerantsite
2. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numresponsablesite
3. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numsuiviadmifinance
4. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numresponsablepeda

1. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numgerantsite
2. UNION
3. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numresponsablesite
4. UNION
5. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numsuiviadmifinance
6. UNION
7. SELECT concat(titregens," ",prenomgens," ",nomgens) FROM gens, centres WHERE numgens = numresponsablepeda

1. SELECT
2.            concat(G1.titregens," ",G1.prenomgens," ", G1.nomgens) as numgerantsite ,           
3.            concat(G2.titregens," ",G2.prenomgens," ", G2.nomgens) as numresponsablesite,           
4.            concat(G3.titregens," ",G3.prenomgens," ", G3.nomgens) as numsuiviadmifinance,           
5.            concat(G4.titregens," ",G4.prenomgens," ", G4.nomgens) as numresponsablepeda
6.        FROM centres
7.        LEFT JOIN gens as G1 on G1.numgens = numgerantsite
8.        LEFT JOIN gens as G2 on G2.numgens = numresponsablesite
9.        LEFT JOIN gens as G3 on G3.numgens = numsuiviadmifinance
10.        LEFT JOIN gens as G4 on G4.numgens = numresponsablepeda

SELECT concat(g1.titregens," ", g1.prenomgens," ", g1.nomgens) AS GERANT, 
concat(g2.titregens," ", g2.prenomgens," ", g2.nomgens) AS RESPSITE, ....
FROM CENTRES c INNER JOIN GENS g1 ON (c.numgerantsite = g1.numgens) 
INNER JOIN GENS g2 ON (c.numresponsablesite = g2.numgens)...