mysql case when 条件判断

 SELECT 
     t1.ORG_NO AS orgNo,t1.ORDER_NO,t1.ORG_SHORT_NAME AS orgName,
     SUM(CASE w.WT_TYPE WHEN   '00' THEN w.WT_NUM ELSE 0 END ) AS wtNum, 
     SUM(CASE w.WT_TYPE WHEN   '05' THEN w.WT_NUM ELSE 0 END ) AS lvWtNum, 
     SUM(CASE w.WT_TYPE WHEN  '06' THEN w.WT_NUM ELSE 0 END ) AS osWtNum,
     SUM(CASE w.WT_TYPE WHEN  '04' THEN w.WT_NUM ELSE 0 END ) AS se2WtNum,
     SUM(CASE w.WT_TYPE WHEN  '03' THEN w.WT_NUM ELSE 0 END ) AS se1WtNum, 
     SUM(CASE w.WT_TYPE WHEN  '02' THEN w.WT_NUM ELSE 0 END ) AS ce2WtNum, 
     SUM(CASE w.WT_TYPE WHEN  '01' THEN w.WT_NUM ELSE 0 END ) AS ce1WtNum
FROM isc_baseorg_sort t1  LEFT JOIN  os_wt_stat_month w