================select u.ID,u.userCode,u.userName,d.departmentname from SysLedgerprivilege l,SysUser u,SysDepartment d where u.userDepartmentid= d.ID and l.userid=u.ID and l.ledgerid=2 and u.userState= 0 order by u.ID ================select u.ID,u.userCode,u.userName,