这条sql语句在mybatis里应该怎样写？
selectuser.idasuid,user.accountasuaccount,user.nameasuname,department.nameasdnamefrom...
select
user.id as uid,
user.account as uaccount,
user.name as uname,
department.name as dname
from
user
join
department
on
user.departmentid=department.id
where
user.id not in (select distinct userid from fraction)
order by user.departmentid 展开
user.id as uid,
user.account as uaccount,
user.name as uname,
department.name as dname
from
user
join
department
on
user.departmentid=department.id
where
user.id not in (select distinct userid from fraction)
order by user.departmentid 展开
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
