81,094
社区成员
发帖
与我相关
我的任务
分享
<select id="getLdTxzDeptSelf" resultMap="exposition" parameterClass="expositionModel">
select e.*,d.name from Exposition e,Department d where e.reportUint=d.deptId
and e.reportUint in (select deptId from Department where fdeptId in
(select fdeptid from Department where d.deptId=$deptId$) and departType=2)
</select>