SQL 报错解决：INSERT INTO wg_purchase_V001 语句错误

这个 SQL 报错的原因是在 SELECT 语句的最后一行不应该有分号。将最后一行的分号删除即可解决该报错。\n\n修改后的 SQL 如下：\n\nINSERT INTO wg_purchase_V001\n (\n PID,\n Pc_GXName,\n Pc_GXValue,\n Pc_Order,\n Pc_GXTotalValue,\n Pc_IsAuto,\n Pc_GxSort,\n Pc_GxPrice,\n Pc_GxNum,\n Pc_IsCheck,\n Pc_GXValue1,\n Pc_GXMan,\n Pc_LIDS,\n Pc_IsCf\n )\nSELECT 653,\n ISNULL(Pl_GxSort1,''),\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue,0)),1),0),\n ISNULL(MAX(pl_order),0) pl_order,\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue,0)),1),0),\n 0,\n ISNULL(Pl_GxSort1,''),\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue,0)),1),0),\n 1,\n 0,\n ISNULL(expr),\n '欧国冬',\n '6515',\n 1\nFROM wg_purchaselist_V001\nWHERE pid =653 and Pl_GxSort1='06木工' and (PLID in (6515) or Pl_GxSort3='欧国冬')\nGROUP BY Pl_GxSort1