sql问题,求解!!!!!!!
赤红冰川 2021-03-19 10:36:14 SELECT ROUND(COUNT(*)/100,1) AS y,t.ct AS x FROM(
SELECT CASE WHEN SUM(b.BRGEW)<=5 THEN '5'
WHEN SUM(b.BRGEW)>5 AND SUM(b.BRGEW)<=10 THEN '5-10'
WHEN SUM(b.BRGEW)>10 AND SUM(b.BRGEW)<=15 THEN '10-15'
WHEN SUM(b.BRGEW)>15 THEN '15' ELSE NULL END ct
FROM bp_db.bs_AL_SALES_AND_ALLOCATION_QUERIESm a JOIN sap_db.AL_PRODUCT_PLAN b ON a.material_numb=b.c_code
/*join cp_db.bs_org_factory d on a.fact_code=d.zplant*/
WHERE SUBSTR(con_date,1,6)=DATE_FORMAT(DATE_ADD(CURDATE(),INTERVAL -1 MONTH),'%Y%m') AND fact_doc not LIKE '%配送%'
AND tos NOT IN('铁运配送','海运配送') AND sale_office NOT IN ('1020','1019','4650','1021')AND cust_name NOT IN ('分仓货损赔偿一次性客户')
GROUP BY a.or_numb )t GROUP BY t.ct
大佬们,这是完整代码,请问fact_doc,tos,sale_office,cust_name这几个字段对应的是那个表里的。