qq_29551899
qq_29551899
2020-05-17 19:12

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

  • oracle
  • mysql
  • java-ee


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};

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答