1 2 3 4 5
| SELECT STOCK_TRACKING.Part_Number, STOCK_TRACKING.Part_Type, STOCK_TRACKING.Description_FR, STOCK_TRACKING.Description_UK, STOCK_TRACKING.Spec, STOCK_TRACKING.Supplier_Code, STOCK_TRACKING.Plant_Code, STOCK_TRACKING.UOM, STOCK_TRACKING.Standard_Price, STOCK_TRACKING.Currency, STOCK_TRACKING.Lead_Time, STOCK_TRACKING.Shelf_Control_Number, STOCK_TRACKING.Storage_Location, STOCK_TRACKING.Users, STOCK_TRACKING.Order_Stop_Reason, STOCK_TRACKING.Order_Stop_Comment, STOCK_TRACKING.Manufact INTO ST1
FROM STOCK_TRACKING
WHERE (((STOCK_TRACKING.Master)=True))
GROUP BY STOCK_TRACKING.Part_Number, STOCK_TRACKING.Part_Type, STOCK_TRACKING.Description_FR, STOCK_TRACKING.Description_UK, STOCK_TRACKING.Spec, STOCK_TRACKING.Supplier_Code, STOCK_TRACKING.Plant_Code, STOCK_TRACKING.UOM, STOCK_TRACKING.Standard_Price, STOCK_TRACKING.Currency, STOCK_TRACKING.Lead_Time, STOCK_TRACKING.Shelf_Control_Number, STOCK_TRACKING.Storage_Location, STOCK_TRACKING.Users, STOCK_TRACKING.Order_Stop_Reason, STOCK_TRACKING.Order_Stop_Comment, STOCK_TRACKING.Manufact
ORDER BY STOCK_TRACKING.Part_Number, STOCK_TRACKING.Shelf_Control_Number; |
Partager