sql 不同字段放到一个字段中

SELECT
    B1.tmbk_date tmbk_date1,
    B2.tmbk_date tmbk_date2,
    B3.tmbk_date tmbk_date3,
    B4.tmbk_date tmbk_date4,
    (case when c.rpt_type_id = '30' then B2.tmbk_date when c.rpt_type_id = '35' then B3.tmbk_date when c.rpt_type_id = '36' then B4.tmbk_date else null end) tmbk_date,
 
    C.back_to_cnt back_to_cnt
FROM
 task C /*任务主表*/
INNER JOIN org B 
ON C.org_id = B.aa_org_id
LEFT JOIN (
    SELECT
        aa_org_biz_fl_id,
        tmbk_date
    FROM
        info_sl
) B1 ON B1.aa_org_biz_fl_id = C.biz_form_id
LEFT JOIN (
    SELECT
        aa_condt_rpt_nbr,
        tmbk_date
    FROM
       RPT
) B2 ON B2.aa_condt_rpt_nbr = C.biz_form_id
LEFT JOIN (
    SELECT
        shdr_condt_rpt_nbr,
        tmbk_date
    FROM
        condt
) B3 ON B3.shdr_condt_rpt_nbr = C.biz_form_id
LEFT JOIN (
    SELECT
        intgrt_condt_rpt_nbr,
        tmbk_date
    FROM
       prsn
) B4 ON B4.intgrt_condt_rpt_nbr = C.biz_form_id

GROUP BY
    C.TASK_PTB_ID
ORDER BY
    TMBK_DATE DESC