多选框数据集根据参数选择不同数据源的字段，t1,t2,t3为不同的三张表
我的思考如下图两种，但是不知道为什么都不成功，求指点
select${if(a=1," distinct countryname as st_name",if(a=2," distinct sourcename as st_name"," distinct product_fname as st_name")} FROM ${if(a=1," t1",if(a=2,"t2"," t3")} wheredate_id between '${date1}' and '${date2}'
select
${if(a=1," distinct countryname as st_name",if(a=2," distinct sourcename as st_name"," distinct product_fname as st_name")}
FROM
${if(a=1," t1",if(a=2,"t2"," t3")}
where
date_id between '${date1}' and '${date2}'
${if(a=1," distinct countryname as st_name",if(a=2," distinct sourcename as st_name"," distinct product_fname as st_name"))}
${if(a=1," t1",if(a=2,"t2"," t3"))}
1min目标场景问卷
立即参与
