关于怎么实现发货累加到下单数量时发货日期??再次提问??

已解决!谢谢!

SELECT b.订单ID, b.下单数量, min(a.交货日期) AS 日期
FROM 表1 AS b INNER JOIN [SELECT *
FROM (SELECT (select Sum(交货数量) from 表2 where 交货日期<=a.交货日期 and 订单ID=a.订单ID) AS 数量, a.*
FROM (select * from 表2 order by 交货日期) a
order by 订单ID,交货日期) a ]. AS a ON b.订单ID=a.订单ID
WHERE a.数量>=b.下单数量
GROUP BY b.订单ID, b.下单数量;