尝试将此活动插入到我的表中,但出现以下错误。有什么想法吗?sql查询检查程序一直在我的insert语句中告诉我它的异常值,但我没有看到任何异常值。谢谢!
INSERT INTO
"_CEL_MD_ACTIVITIES" ("_CEL_MD_ACTIVITIES"."CASE_KEY", "_CEL_MD_ACTIVITIES"."ACTIVITY_EN", "_CEL_MD_ACTIVITIES"."EVENTTIME")
SELECT
"_CEL_MD_CASE_TABLE"."CASE_ID" AS "_CEL_MD_ACTIVITIES"."CASE_KEY",
'Case Reopened' AS "_CEL_MD_ACTIVITIES"."ACTIVITY_EN",
"_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" AS "_CEL_MD_ACTIVITIES"."EVENTTIME"
FROM
"_CEL_MD_CASE_TABLE"
JOIN
"_CEL_MD_ACTIVITIES"
ON "_CEL_MD_CASE_TABLE"."CASE_ID" = "_CEL_MD_ACTIVITIES"."CASE_KEY"
WHERE
"_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" IS NOT NULL;
执行错误:[vertica]vjdbc错误:语法错误在“”处或附近
1条答案
按热度按时间kfgdxczn1#
将联接中涉及的表的名称和字段用作别名。例如
这是不对的。您应该更改别名,不要在其中使用点(.)或删除别名的用法