select unitcode from g3_unit where unitname like'%部门001%'这个可以查询出来
select unitno from g3_unit where unitcode like '1___'这个也可以查询出来
select unitno from g3_unit where unitcode like '(select unitcode from g3_unit where unitname like'%部门001%')___' 这两个加起来就不行了,我知道肯定是我写法的问题,请问各位大神怎么改一下?