5,889
社区成员
发帖
与我相关
我的任务
分享
select distinct a.STAFF_ID as staffId,
a.STAFF_NAME as staffName,
a.STAFF_NO as staffNo,
a.ROLE_ID as roleId,
a.ROLE_NAME as roleName,
a.ROLE_TYPE as roleType,
V.PARENTS AS parents,
a.ROLE_BE_NAME as roleBeName
from view_sys_user_role a
LEFT OUTER JOIN VIEW_ROLE_DERIVE V ON V.SON_ROLE_ID = a.ROLE_ID
where 1 = 1 and (a.ROLE_ID is not null or a.ROLE_NAME is not null or a.ROLE_BE_NAME is not null)
<[ AND a.STAFF_ID = :staffId]>
order by a.ROLE_BE_NAME, a.ROLE_NAME
这个语句在oracle里争吵,在db2里出错,把distinct去掉,就能查到数据了。