sql语句，case then的使用例子

根据 s.record_type 的值选择跟哪个表做表连接，获取区域名属性

SELECT s.split_id ,s.split_amount,s.split_time,
    (CASE 
        WHEN s.record_type = 0 
            THEN (SELECT b.region_name FROM pl_region_consume_summary_t a,pl_region_t b WHERE a.region_id=b.region_id AND a.summary_id = s.summary_id )
        ELSE
      (SELECT d.region_name FROM pl_region_electric_bill_t c,pl_region_t d WHERE c.region_id=d.region_id AND c.record_id = s.summary_id )
        END
    ) AS regionName
FROM pl_income_split_details_t s where s.withdrawal_record_id = 1;