SELECT ${if(SQL("BIDB","SELECT SUBSTR(BELONG_UNIT,1,5) as com_code,SUBSTR(T1.BELONG_UNIT,INSTR(T1.BELONG_UNIT,'_')+1,LENGTH(T1.BELONG_UNIT)-INSTR(T1.BELONG_UNIT,'_')) AS UNIT FROM INPUT_CW_LRZX_WH T1 LEFT JOIN INPUT_CW_YSE_WH T2 ON T1.PROFIT_DISPLAY_NAME = T2.PROFIT_CENTER WHERE PROPERTIES = '前台' AND T1.PROFIT_DISPLAY_NAME = '" + comboBox0 + "'",1,1) == '01501','T2.UNIT','T2.PROFIT_CENTER')} ,T2.RATE_BUDGET FROM INPUT_CW_LRZX_WH T1 LEFT JOIN INPUT_CW_YSE_WH T2 ON T1.PROFIT_DISPLAY_NAME = T2.PROFIT_CENTER WHERE PROPERTIES = '前台' AND T1.PROFIT_DISPLAY_NAME = '${comboBox0}' 查询处理是这种 |