| 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' 数据集是这样的，  参数：机组编号，班值为空时查询全部。 |
