还算简单:create procedure 存储过程名
@p int
as
Select * from manage_dept where (id in (select distinct deptid from manage_user where id<>1 and leave=0) or id in(select parent from manage_dept )) and parent=@p order by number
@p int
as
Select * from manage_dept where (id in (select distinct deptid from manage_user where id<>1 and leave=0) or id in(select parent from manage_dept )) and parent=@p order by number
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货