SQL 报错解决：INSERT 语句中 SELECT 语句位置错误

{"title":"SQL 报错解决：INSERT 语句中 SELECT 语句位置错误","description":"本文介绍了 SQL 语句中 INSERT 和 SELECT 语句位置错误导致的报错问题，并提供了正确的 SQL 语句示例，帮助你解决类似的 SQL 报错问题。","keywords":"SQL 报错, INSERT 语句, SELECT 语句, SQL 错误, 数据库错误, SQL 语法错误, INSERT INTO, SELECT FROM, GROUP BY","content":"这个 SQL 语句报错是因为最后一行的语句没有正确放在 SELECT 语句的后面。应该将最后一行的语句放在 SELECT 语句的末尾，而不是在 GROUP BY 子句的后面。正确的 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\n 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,\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue,0)),1),0)\nFROM wg_purchaselist_V001\nWHERE pid = 653\n AND Pl_GxSort1 = '06木工'\n AND (PLID IN (6515) OR Pl_GxSort3 = '欧国冬')\nGROUP BY Pl_GxSort1;"}