现在需要在一个mybatis的select标签内同时查询多张表的数据，要怎么写啊？

Question

select count(1) from tab_1 t where TO_CHAR(t.date,'YYYYMMDD')=#{date};
select count(1) from tab_2 t where TO_CHAR(t.date,'YYYYMMDD')=#{date};
select count(1) from tab_3 t where TO_CHAR(t.date,'YYYYMMDD')=#{date};
select count(1) from tab_4 t where TO_CHAR(t.date,'YYYYMMDD')=#{date};

Answer 1

用union或者union all，具体怎么用，查用法