1 2
| SELECT DISTINCT S3.A_S3, S3.L_S3, S2.A_S2, S2.L_S2, S1.A_S1, S1.L_S1
FROM (((SELECT DISTINCT S1b.A_S2, S1b.L_S2, Base.Article AS A_S1, Base.Lot AS L_S1 FROM (SELECT DISTINCT Base.Article AS A_S2, Base.Lot AS L_S2, Base.Ordre AS O_S2 FROM (SELECT DISTINCT S3.A_S3, S3.L_S3, Base.Article AS A_S2, Base.Lot AS L_S2, Base.Ordre AS O_S2 FROM (SELECT DISTINCT Base.Ordre AS O_S3, Base.Article AS A_S3, Base.Lot AS L_S3 FROM Base WHERE (((Base.Article)=[S3]) AND ((Base.Mvt)=101))) AS S3 INNER JOIN Base ON S3.O_S3 = Base.Ordre WHERE (((Base.Article)=[S2]) AND ((Base.Mvt)=261))) AS S2 INNER JOIN Base ON (S2.A_S2 = Base.Article) AND (S2.L_S2 = Base.Lot) WHERE (((Base.Mvt)=101))) AS S1b INNER JOIN Base ON S1b.O_S2 = Base.Ordre WHERE (((Base.Article)=[S1]) AND ((Base.Mvt)=261))) AS S1 INNER JOIN (SELECT DISTINCT Base.Article AS A_S2, Base.Lot AS L_S2, Base.Ordre AS O_S2 FROM (SELECT DISTINCT S3.A_S3, S3.L_S3, Base.Article AS A_S2, Base.Lot AS L_S2, Base.Ordre AS O_S2 FROM (SELECT DISTINCT Base.Ordre AS O_S3, Base.Article AS A_S3, Base.Lot AS L_S3 FROM Base WHERE (((Base.Article)=[S3]) AND ((Base.Mvt)=101))) AS S3 INNER JOIN Base ON S3.O_S3 = Base.Ordre WHERE (((Base.Article)=[S2]) AND ((Base.Mvt)=261))) AS S2 INNER JOIN Base ON (S2.L_S2 = Base.Lot) AND (S2.A_S2 = Base.Article) WHERE (((Base.Mvt)=101))) AS S1b ON (S1.L_S2 = S1b.L_S2) AND (S1.A_S2 = S1b.A_S2)) INNER JOIN (SELECT DISTINCT S3.A_S3, S3.L_S3, Base.Article AS A_S2, Base.Lot AS L_S2, Base.Ordre AS O_S2 FROM (SELECT DISTINCT Base.Ordre AS O_S3, Base.Article AS A_S3, Base.Lot AS L_S3 FROM Base WHERE (((Base.Article)=[S3]) AND ((Base.Mvt)=101))) AS S3 INNER JOIN Base ON S3.O_S3 = Base.Ordre WHERE (((Base.Article)=[S2]) AND ((Base.Mvt)=261))) AS S2 ON (S1b.L_S2 = S2.L_S2) AND (S1b.A_S2 = S2.A_S2)) INNER JOIN (SELECT DISTINCT Base.Ordre AS O_S3, Base.Article AS A_S3, Base.Lot AS L_S3 FROM Base WHERE (((Base.Article)=[S3]) AND ((Base.Mvt)=101))) AS S3 ON (S2.L_S3 = S3.L_S3) AND (S2.A_S3 = S3.A_S3); |
Partager