select a.*,case when b.zhuanban is null then 0 else b.zhuanban end from(

    select a.*,case when b.db is null then 0 else b.db end from(

        select a.*,case when b.zb is null then 0 else b.zb end from (

            select loginname,realname from sys_user where unitid = '0203'

        )a left join (select loginname,count(1) zb from slj_info where letterstate = 8  --zhiban

            group by loginname

        )b on a.loginname = b.loginname

    )a left join (select loginname,count(1) db from slj_info where letterstate = 9  --duban

        group by loginname

    )b on a.loginname = b.loginname

)a left join (select loginname,count(1) zhuangban from slj_zhuanban

    group by loginname

)b on a.loginname = b.loginname

最后一张slj_zhuanban怎么和前面的拼接在一起