select
a.zbts,
a.zbid,
b.txt,
a.zbval,
a.dtbegin,
a.dtend,
a.reason
from tab_dian_store_jzqt a, tab_dian_base_zhibiao2 b
where 1=1 and
a.zbid = b.zbid and
a.zbts >= to_date('${date_query}','yyyy-MM')
and a.zbts <= last_day(to_date('${date_query}','yyyy-MM'))
and a.unit = '${unit}'
and a.bak1 = '${zhi}'
and class1 = '5' and class2 = '3'
数据集是这样的,
31425
参数:机组编号,班值为空时查询全部。