金蝶用户组权限语句

select  a.fname ,c.fname as  fgroupname  from   t_user  a
inner join  t_group   b  on a.FUserID =b.FUserID
inner join  #temp c on c.fuserid =b.FGroupID
where  a.FForbidden =0
order by a.fname 

select * from   t_user

select *into  #temp from  t_User where fuserid <100

  

posted @ 2019-07-08 07:45  zhuguoqing  阅读(337)  评论(0编辑  收藏  举报