为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:银河麒麟V10
【CPU】:AMD64
【问题描述】*:
SQL第6行2022_finish AS Finish2022 别名报错, 去掉AS Finish2022, 能正常查询。
SELECT id,parent_id,node_name,node_code,node_type,node_no,budgetary_overrun,status,
project_id,create_by,create_dept,created_date,last_modified_by,last_modified_date,
is_deleted AS deleted,sort,tenant_id,is_relation_bill AS relationBill,
remark,path,conversion_unit,is_relation_catalogue AS relationCatalogue,
is_merge AS merge,budget_type,
"2022_finish" AS Finish2022,total_finish_money
FROM invest_budgetary_estimate_catalogue
2022_finish加上双引号就可以了
path,merge加上双引号试试