imp_yunwei/银行客商查询.txt

银行客商查询

select sd2.dept_name, b.dept_name,count(*) from custbank b
LEFT JOIN SYS_DEPARTMENT sd ON b.DEPT_ID = sd.ID 
LEFT JOIN SYS_DEPARTMENT sd2 ON sd2.DEPT_CODE = sd.f_id

 where  b.ctStatus = '已准入'
group by sd2.dept_name,b.dept_name