1 2 3 4 5 6 7 8 9
| sReq = "SELECT Article.Code AS Code, Article.Nom AS Libelle, Article.Pamp AS PAMP, Article.StockPhyGen AS StockPhys, (SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DP"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDP," +...
"(SELECT Stock.StockPhy FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPT"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS DPT, (SELECT Stock.RelCli FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPT"" ORDER BY " +...
"Stock.CodeArticle,Stock.CodeDepot) AS CliDPT, (SELECT Stock.RelFour FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPT"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS FourDPT,(SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code " + ...
"AND Stock.CodeDepot = ""DPT"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDPT, (SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPTEB"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDPTEB, (SELECT Stock.SeuilSecu " + ...
"FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPTXB"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDPTXB, (SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DPTAL"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) " + ...
"AS MiniDPTAL, (SELECT Stock.StockPhy FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DN"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS DPN, (SELECT Stock.RelCli FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DN"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) " + ...
"AS CliDPN, (SELECT Stock.RelFour FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DN"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS FourDPN,(SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DN"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) " + ...
"AS MiniDPN, (SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DNEB"" ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDPNEB, (SELECT Stock.SeuilSecu FROM Stock WHERE Stock.CodeArticle = Article.Code AND Stock.CodeDepot = ""DNXB"" " + ...
"ORDER BY Stock.CodeArticle,Stock.CodeDepot) AS MiniDPNXB, Article.NombreParColis AS NbParColis, Article.StockMinGen AS StockMini FROM [Article] WHERE Article.Sommeil = 0 ORDER BY Article.Code" |
Partager