日期:2014-05-17 浏览次数:20824 次
select * from t_sys_res tsr where tsr.zybh in (
select tsrr.zyid from t_sys_res_role tsrr where tsrr.jsid in (
select tsru.jsbh from t_sys_role_user tsru where tsru.yhbh='1'
)
);
select tsr.*
from t_sys_res tsr
left join t_sys_res_role tsrr on tsr.zybh = tsrr.zyid
left join t_sys_role_user tsru on tsrr.jsid = tsru.jsbh and tsru.yhbh='1'
where tsrr.zyid is not null and tsru.jsbh is not null
;