注册

数据库创建视图语句报错

篮球玩家 2024/06/06 483 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:linux
【CPU】:2核8g
【问题描述】*:数据库创建视图语句报错
语句:AS "UNIT_NAME","U"."COOPERATIVE_GROUP" AS "COOPERATIVE_GROUP","F"."ANNUAL" AS "ANNUAL","W"."TOTAL_SCORE"
AS "WORK_SCORE","S"."TOTAL_SCORE" AS "SECURITY_SCORE","D"."TOTAL_SCORE" AS "DEVELOP_SCORE","I"."TOTAL_SCORE"
AS "INFO_SCORE","R"."TOTAL_SCORE" AS "RESOURCE_SCORE",(select count("E"."FILE_PATH")
from "SGPORTAL"."SG_EXCELLENT_CONDITION" "E" where (("E"."FILE_PATH" is not null) and ("E"."FILE_PATH" <> '')
and ("E"."IS_DELETED" = 0) and ("E"."FILLING_ID" = "F"."ID")))
AS "EXTRA_SCORE",((((("W"."TOTAL_SCORE" + "S"."TOTAL_SCORE") + "D"."TOTAL_SCORE") + "I"."TOTAL_SCORE") + "R"."TOTAL_SCORE") +
(select count("E"."FILE_PATH") from "SGPORTAL"."SG_EXCELLENT_CONDITION" "E"
where (("E"."FILE_PATH" is not null) and ("E"."FILE_PATH" <> '') and ("E"."IS_DELETED" = 0)
and ("E"."FILLING_ID" = "F"."ID")))) AS "TOTAL_SCORE"
from (((((("SGPORTAL"."SG_FILING" "F" join "SGPORTAL"."SG_WORKING_MECHANISM" "W")
join "SGPORTAL"."SG_SECURITY_MANAGEMENT" "S") join "SGPORTAL"."SG_DEVELOPMENT_USE" "D") join "SGPORTAL"."SG_INFORMATION_BUILD" "I") join "SGPORTAL"."SG_RESOURCE_MANAGEMENT" "R") join "SGPORTAL"."SG_UNIT" "U") where (("F"."IS_DELETED" = 0) and ("W"."IS_DELETED" = 0) and ("S"."IS_DELETED" = 0) and ("D"."IS_DELETED" = 0) and ("I"."IS_DELETED" = 0) and ("R"."IS_DELETED" = 0) and ("U"."IS_DELETED" = 0) and ("F"."UNIT_CODE" = "U"."CODE" ) and ("F"."ID" = "W"."FILLING_ID") and ("F"."ID" = "S"."FILLING_ID") and ("F"."ID" = "D"."FILLING_ID") and ("F"."ID" = "I"."FILLING_ID") and ("F"."ANNUAL" = "R"."ANNUAL") and ("F"."UNIT_CODE" = "R"."UNIT_CODE"));

报错信息:
977ca7a1230c6992f8208578d9481478.png

回答 0
暂无回答
扫一扫
联系客服