在报表文件里的sql如何通过不同条件查询数据结果? 需求是这样的:
我查询一张表的数据,我们用户界面会传入条件参数,我要根据这个参数值的不同,使用不同的sql条件查询,这个如何实现?
with t1 as (--参数a
select a as value1
,b as value2
from table1
) t2 as (--参数b
select c as value1
,d as value2
from table2
)
select * from
${if(参数==a,"t1","t3")}