56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT a.id,o.*,a.reMonery+SUM(IFNULL(r.reMonery,0)),o.money-(a.reMonery+SUM(IFNULL(r.reMonery,0))),a.reTime
FROM record a
LEFT JOIN `order` o ON o.orderId = a.orderId
LEFT JOIN (SELECT r.*,a.reTime AS 'r' FROM record a
LEFT JOIN record r ON a.orderId = r.orderId
WHERE r.reTime < a.reTime
ORDER BY r.reTime
) r ON r.r = a.reTime AND a.orderId = r.orderId
GROUP BY a.id
SELECT a.id,o.*,a.reMonery+SUM(IFNULL(r.reMonery,0)),o.money-(a.reMonery+SUM(IFNULL(r.reMonery,0))),a.reTime
FROM record a
LEFT JOIN ORDER o ON o.orderId = a.orderId
LEFT JOIN (SELECT r.*,a.reTime AS 'r' FROM record a
LEFT JOIN record r ON a.orderId = r.orderId
WHERE r.reTime < a.reTime
ORDER BY r.reTime
) r ON r.r = a.reTime
GROUP BY a.id