select * from t_hzoa_sys_user t where t.id in (select t2.userid from t_hzoa_sys_role_user t2 where t2.roleid = 11981);
sql in用法
最新推荐文章于 2024-08-09 23:23:34 发布
select * from t_hzoa_sys_user t where t.id in (select t2.userid from t_hzoa_sys_role_user t2 where t2.roleid = 11981);