麻烦神通广大的带火，给一些指点
【DM版本】:7
【操作系统】：windows
【CPU】:
【问题描述】*：mysql 迁移至达梦，视图表创建发生 第 25 行, 第 60 列[)]附近出现错误[-2007]:
语法分析出错。在这句“）”附近

              (("synthetical"."t_docrole" "r"
            join "synthetical"."t_docrole_user" "u")

原语句：
CREATE
VIEW "synthetical"."v_user_doccategory"
(
"CATEGORY_ID" ,
"CATEGORY_NAME",
"ORDER_NO" ,
"PARENT_ID" ,
"USER_ID"
) AS
select
"c"."CATEGORY_ID" AS "CATEGORY_ID" ,
"c"."CATEGORY_NAME" AS "CATEGORY_NAME",
"c"."ORDER_NO" AS "ORDER_NO" ,
"c"."PARENT_ID" AS "PARENT_ID" ,
"t1"."USER_ID" AS "USER_ID"
from
("synthetical"."t_doccategory" "c"
join
(
select
"a"."CATEGORY_ID" AS "CATEGORY_ID",
"u"."USER_ID" AS "USER_ID"
from
(("synthetical"."t_docrole" "r"
join "synthetical"."t_docrole_user" "u")
join "synthetical"."t_docrole_category_search" "a")
where
(
(
"r"."ROLE_ID" = "u"."ROLE_ID"
)
and
(
"r"."ROLE_ID" = "a"."ROLE_ID"
)
)
)
"t1")
where
(
"c"."CATEGORY_ID" = "t1"."CATEGORY_ID"
);