27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT DATE.`yymm`,
all_data.PRODUCT_NAME,
all_data.`統括部`,
all_data.`小BU`,
m_munber_list.`担当者` AS M_munber,
v_munber_list.`担当者` AS V_munber,
v_munber_list.`资本粗分`,
SUM(all_data.SO_QUANTITY),
SUM(all_data.SALES_AMOUNT_SC),
SUM(all_data.PURCHASE_AMOUNT_SC)
FROM all_data
INNER JOIN DATE
ON all_data.SO_DATE = DATE.yymmdd AND DATE.`月` IN (04, 05, 06)
INNER JOIN m_munber_list
ON m_munber_list.Classify_Code = all_data.CLASSIFY_CODE
INNER JOIN v_munber_list
ON v_munber_list.Brand_Code = all_data.Brand_Code
GROUP BY
DATE.`yymm`,
all_data.`統括部`,
all_data.`小BU`,
all_data.product_name,
m_munber_list.`担当者`,
v_munber_list.`担当者`,
v_munber_list.`资本粗分`
这样看看能不能快一点?