1 2 3 4 5
| INSERT INTO Table1 ( refart, lot, date_mvt, Rangée, Col, Niv, Pos, Prof )
SELECT dbo_Emplacem.Refart, dbo_Emplacem.NumLot, dbo_HistoMvt.DateMouvt, dbo_Emplacem.TextSto, dbo_Emplacem.TextCol, dbo_Emplacem.TextPlat, dbo_Emplacem.TextLarg, dbo_Emplacem.PosProf
FROM dbo_HistoMvt INNER JOIN (dbo_Emplacem AS dbo_Emplacem_1 INNER JOIN dbo_Emplacem ON (dbo_Emplacem_1.NumLot = dbo_Emplacem.NumLot) AND (dbo_Emplacem_1.Refart = dbo_Emplacem.Refart) AND (dbo_Emplacem_1.TextSto = dbo_Emplacem.TextSto) AND (dbo_Emplacem_1.TextCol = dbo_Emplacem.TextCol) AND (dbo_Emplacem_1.TextPlat = dbo_Emplacem.TextPlat) AND (dbo_Emplacem_1.PosProf = dbo_Emplacem.PosProf)) ON (dbo_HistoMvt.NumLot = dbo_Emplacem.NumLot) AND (dbo_HistoMvt.Refart = dbo_Emplacem.Refart) AND (dbo_HistoMvt.Posprof = dbo_Emplacem.PosProf)
GROUP BY dbo_Emplacem.Refart, dbo_Emplacem.NumLot, dbo_HistoMvt.DateMouvt, dbo_Emplacem.TextSto, dbo_Emplacem.TextCol, dbo_Emplacem.TextPlat, dbo_Emplacem.TextLarg, dbo_Emplacem.PosProf
HAVING (((dbo_Emplacem.Refart)=[Saisir votre référence])); |
Partager