2条回答
- 子幽 2017-10-12 09:13关注
select a.id,sum(b.BZSC) from A as a left join B as b on a.start_date < b.dates and a.end_date > b.date where 1
逻辑是这样,不知道写错没,菜鸟一个
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
select a.id,sum(b.BZSC) from A as a left join B as b on a.start_date < b.dates and a.end_date > b.date where 1
逻辑是这样,不知道写错没,菜鸟一个