${if(len(zzzid) == 0, “from table1”,”from table2”)} 现在的取值逻辑是这样写的,zzzid为0取表一
zzzid 不为取表2。能不能在里面加一个and拼接实现 如果zzzid为0取表一和表一的code1字段,如果zzzid不为0取表2和表2的code2字段
我是这样写的不知道对不对
${if(len(zzzid) == 0, “select code1 as code from table1”,”select code2 as code from table2”)}
=======
你的应该这样
${if(len(zzzid) == 0, “from table1 where code1='”+zzzid+"'",”from table2 where code2='”+zzzid+"'")}
select
${if(len(zzzid) == 0, name1,name2)}
from
${if(len(zzzid) == 0, table1,table2)}