SELECT
        "学科招聘", 
        hc.channelName 一级渠道, 
        a.二级渠道 二级渠道
    FROM
        (SELECT
            channelId,
            channelName 二级渠道,
            channelPid
        FROM
            view_hrm_channel
        WHERE
            channelPid <> 0) a
    left join
        view_hrm_channel hc on a.channelPid = hc.channelId
    
    
    SELECT
        "客关", 
        ch.name 一级渠道, 
        a.二级渠道 二级渠道
    FROM
        (SELECT
            id,
            name 二级渠道,
            Pid
        FROM
            channel
        WHERE
            Pid <> 0) a
    left join
        channel ch on a.Pid = ch.id
    
    SELECT
        "职能", 
        sk.channelName 一级渠道, 
        a.二级渠道 二级渠道
    FROM
        (SELECT
            channelId,
            channelName 二级渠道,
            channelPid
        FROM
            skill_channel
        WHERE
            channelPid <> 0) a
    left join
        skill_channel sk on a.channelPid = sk.channelId
    文档更新时间: 2019-03-08 11:44   作者:admin