select a.* from sys_user a
where exists(select 1 from sys_dept b where a.dept_id=b.id_)
转载于:https://my.oschina.net/u/3023191/blog/1553374
select a.* from sys_user a
where exists(select 1 from sys_dept b where a.dept_id=b.id_)
转载于:https://my.oschina.net/u/3023191/blog/1553374