SELECT op.OP_CODE , op.OP_NAME ,( case when ( re.RES_ID IS NULL )then 0 else 1 end ) state
FROM SYS2_OPERATION op
LEFT JOIN SYS2_RES_OPE ro on op.OP_ID = ro.OP_ID
LEFT JOIN SYS2_RESOURCE re on re.RES_ID = ro.RES_ID
AND re.RES_ID = '1'
FROM SYS2_OPERATION op
LEFT JOIN SYS2_RES_OPE ro on op.OP_ID = ro.OP_ID
LEFT JOIN SYS2_RESOURCE re on re.RES_ID = ro.RES_ID
AND re.RES_ID = '1'
3272
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
