这个SQL报错怎么解决 INSERT INTO wg_purchase_V001 PID Pc_GXName

这个SQL报错的原因是在SELECT语句的最后一行不应该有分号。将最后一行的分号删除即可解决该报错。

修改后的SQL如下：

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