1 2 3 4 5 6 7 8
|
INSERT INTO Historique (Proprietaire, Adresse, Numero, Utilisateur, Motif, DateSortie, DateRetour, Code, Agent)
SELECT DISTINCT ClefTableau.Proprietaire AS ClefProprietaire, ClefTableau.Adresse AS ClefAdresse, ClefTableau.Numero AS ClefNumero, ClefSortie.Utilisateur AS SortieUtilisateur, ClefSortie.Motif AS SortieMotif, ClefSortie.DateSortie AS SortieSortie, ClefSortie.DateRetour AS SortieRetour, Trousseaux.Code AS TrousseauxCode, Agents.Nom AS AgentsAgent
FROM ((ClefTableau LEFT OUTER JOIN Trousseaux ON Trousseaux.NumTableau = ClefTableau.NumTableau)
INNER JOIN ClefSortie ON ClefSortie.NumTrousseau = Trousseaux.NumTrousseau)
INNER JOIN Agents ON ClefSortie.NumAgent = Agents.NumAgent
WHERE
(ClefSortie.NumTrousseau = '71') |
Partager