The SQL statement you provided is not valid. There is a syntax error in the GROUP BY clause. The correct syntax should be:

INSERT INTO wg_purchase_V001 (
    PID,
    Pc_GXName,
    Pc_GXValue,
    Pc_Order,
    Pc_GXTotalValue,
    Pc_IsAuto,
    Pc_GxSort,
    Pc_GxPrice,
    Pc_GxNum,
    Pc_IsCheck,
    Pc_GXValue1,
    Pc_GXMan,
    Pc_LIDS,
    Pc_IsCf
)
SELECT
    653,
    ISNULL(Pl_GxSort1, ''),
    ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),
    ISNULL(MAX(pl_order), 0) pl_order,
    ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),
    0,
    ISNULL(Pl_GxSort1, ''),
    ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),
    1,
    0,
    ISNULL(expr),
    '欧国冬',
    '6515',
    1
FROM
    wg_purchaselist_V001
WHERE
    pid = 653
    AND Pl_GxSort1 = '06木工'
    AND (PLID IN (6515) OR Pl_GxSort3 = '欧国冬')
GROUP BY
    Pl_GxSort1;

The error you mentioned, "ISNULL(ROUND(SUM(IFNULL(pl_GXValue,0)),1),0)", is not a standalone SQL statement. It is part of the SELECT clause within the INSERT INTO statement

INSERT INTO wg_purchase_V001	 	 PID	 Pc_GXName

原文地址: http://www.cveoy.top/t/topic/h14B 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录