查询不出数据来,请问哪里有问题呢 select case when ( MMMBWCS2= 'Y0115' or MMMBWCS2 ='Y0103' or MMMBWCS2 ='Y0105') then drschjg_qy else drschjg_cy end as schjg,orgcode, provincename from( select a.drschjg_qy,a.drschjg_cy, a.orgcode, a.provincename, b.MMMBWCS2 from app_yc_jcljgjschjc_ORC a join ALL_D05.ERP_AC_YPYC_PFJG_GRAPH b on a.orgcode = b.zxnjg where a.calday = '${tjdate}' ${IF(yppz=="",""," AND b.MMMBWCS2 IN ("+yppz+")")} group by b.MMMBWCS2 ) |