1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| WITH tree (idArticle,idNomenc,nature,designation)
AS
( SELECT RTRIM(A.ARKTCODART) AS idArticle, RTRIM(N.NOCTCODECP) AS idNomenc, N.NOCTNATCPT AS nature, RTRIM(N.NOCTLIBCOM) AS designation
FROM NOMENC AS N
INNER JOIN ARTICLE AS A
ON N.NOCTCODECP = A.ARKTCODART
WHERE N.NOKTSOC = '200' -- ID DE LA SOCIETE (ne pas y tenir compte)
AND N.NOKTCODPF = '62085' -- ID DE L'ARTICLE PRINCIPAL
UNION ALL
SELECT RTRIM(A.ARKTCODART) AS idArticle, RTRIM(N.NOCTCODECP) AS idNomenc, N.NOCTNATCPT AS nature, RTRIM(N.NOCTLIBCOM) AS designation
FROM NOMENC AS N
INNER JOIN ARTICLE AS A
ON N.NOCTCODECP = A.ARKTCODART
INNER JOIN tree AS T
ON T.idNomenc = N.NOCTCODECP
)
SELECT * FROM tree WHERE nature = '6' -- La nature '6' correspond à un produit fabriqué |
Partager