ช่วงเวลา : 28|21
SELECT AREA,ZONE,SUM(case when TYPE <> 'CN' then QTY else 0 end) as QTY,SUM(case when TYPE <> 'SALE' then QTY else 0 end) as QTY_CN,SUM(case when QTY > 0 AND TYPE <> 'CN' then SUMCUS else 0 end) as SUMCUS,GROUPP,YEARR,MONTHH,LAST_INSERT,SALE_CODE
FROM 12sku_group_customer_042025
WHERE MONTHH ='04' AND YEARR = '2025'
GROUP BY AREA,ZONE,GROUPP,YEARR,MONTHH
ORDER BY AREA,GROUPP;
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\www\12SKU\insert_12sku_data.php on line 68
เดือน 04 ปี 2025 จำนวน : 0 แถว