1 2 3 4 5
|
SELECT TOP 4 STOCKS_CONGELES.STK_CODE, STOCKS_CONGELES.ART_CODE, STOCKS_CONGELES.STK_DENT, STOCKS_CONGELES.STK_NUMPAL, STOCKS_CONGELES.STK_PICKING, FICHES_ARTICLES.ART_LIBELLE1, STOCKS_CONGELES.STK_PBRUT, STOCKS_CONGELES.STK_TPAL, STOCKS_CONGELES.STK_TCART, STOCKS_CONGELES.STK_PNET, STOCKS_CONGELES.STK_LOT1, STOCKS_CONGELES.STK_LOT2, STOCKS_CONGELES.STK_LOT3, STOCKS_CONGELES.STK_LOT4, STOCKS_CONGELES.STK_LOT5, STOCKS_CONGELES.STK_LOT6, STOCKS_CONGELES.STK_DATECONG, STOCKS_CONGELES.STK_DLUO, STOCKS_CONGELES.STK_OUTDATE
FROM FICHES_ARTICLES INNER JOIN STOCKS_CONGELES ON FICHES_ARTICLES.ART_CODE = STOCKS_CONGELES.ART_CODE
WHERE (((STOCKS_CONGELES.STK_PICKING)<>"") AND ((FICHES_ARTICLES.ART_LIBELLE1)="CUR") AND ((STOCKS_CONGELES.STK_OUTDATE) Is Null))
ORDER BY STK_DENT ASC; |
Partager