Bonjour tout le monde j'ai un petit souci concernant une requête
d'après les tables que j'ai en dessous en Annexe 1 je veux créer une requête INSERT afin d'avoir un résultat comme suit sur la table affichage :
je vous remercie infiniment pour le temps que vous me consacré


[CODE]
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| IDPointages | UIDEmployePointages | IDEmployePointages | Nom | DatePointages | salle | seances |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| 1 | 999 | 999 | DAVID | 2023-02-26 | A3 | S1 |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| 2 | 224 | 224 | Beat | 2023-02-26 | A3 | S1 |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| 3 | 65 | 65 | Jean | 2023-02-26 | A3 | S1 |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| 4 | 64 | 64 | Xavier| 2023-02-26 | A3 | S1 |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
[/CODE]
Annexe 1 :


table affichage:
[CODE]
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| IDPointages | UIDEmployePointages | IDEmployePointages | Nom | DatePointages | salle | seances |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
| 1 | 999 | 999 | DAVID | 2023-02-26 | A3 | S1 |
+-------------+---------------------+--------------------+-------+---------------+-------+---------+
[/CODE]



table affectation:
[CODE]
+---------------+------------+-----------+
| IDAffectation | IDEmployes | IDService |
+---------------+------------+-----------+
| 1 | 224 | 6 |
| 2 | 65 | 6 |
| 3 | 64 | 6 |
| 480 | 999 | 6 |
+---------------+------------+-----------+
[/CODE]

table employes:
[CODE]
+-------------+------------+--------------------+
| UIDEmployes | IDEmployes | NomCompletEmployes |
+-------------+------------+--------------------+
| 224 | 224 | Bea |
+-------------+------------+--------------------+
| 65 | 65 | Jean |
+-------------+------------+--------------------+
| 64 | 64 | Xavier |
+-------------+------------+--------------------+
| 999 | 999 | DAVID |
+-------------+------------+--------------------+
[/CODE]