大概sql如下：

select y.id                      AS "id",
       t.rule_desen_name         AS "desensitizationRuleName",
       t.rule_encry_name         AS "securityRuleName"
from tabley y
         left join tableyc c on c.id = y.data_type_id
         left join tableyb b on c.safe_class = b.id
         left join (select f.id,
                           d.rule_name as "rule_desen_name",
                           e.rule_name as "rule_encry_name"
                    from tableyf f
                             left join tableya a on f.id = a.config_audit_id
                             left join tableyd d on d.id = a.desensitization_rule_id
                             left join tableye e on e.id = a.security_rule_id
                    where 1 = 1) t on id = id
where 1 = 1;

在mysql中是可以正常执行的，但是在dm8里面就提示--无法解析的成员访问表达式[T.RULE_DESEN_NAME]