22,210
社区成员
发帖
与我相关
我的任务
分享
1.select * from tb1 a join tb2 b on a.id=b.id
where a.time between t11 and t12 and b.time between t21 and t22
2.select * from tb1 a join tb2 b on a.id=b.id and b.time between t21 and t22
where a.time between t11 and t12