590
社区成员
发帖
与我相关
我的任务
分享
SELECT a.ID,b.min_time,a.max_time,SUM(b.[no]) AS [no] FROM A INNER JOIN B ON a.ID=b.ID AND a.min_time<b.max_time AND b.min_time<a.max_time GROUP BY a.ID,b.min_time,a.max_time
SELECT a.*,b.[no] FROM A INNER JOIN B ON a.ID=b.ID AND a.min_time<b.max_time AND b.min_time<a.max_time
给你写一个看看是不是这样效果