原有:SELECT * FROM bigdata.GLR_B_ORG_INFO WHERE 1=1 ${if(a="吉林榆银村镇银行管理部", "and flag=1"," AND (org_cd=(select org_cd from bigdata.GLR_B_ORG_INFO where org_id= '"+a+"') or parent_org_cd =(select org_cd from bigdata.GLR_B_ORG_INFO where org_id='"+a+"'))")} -------------------- 在原有的,加另一个判断条件: a="长春朝阳和润村镇银行总行汇总", "and flag=2" 怎么改 |
最佳回答 |
||||
0
|
|