[quote=引用 5 楼 weixin_44779306 的回复:] [quote=引用 3 楼 吉普赛的歌 的回复:] 用开窗函数是可以做的。 没太多时间了, 写个大概: select * ,(select sum(定金) from test2 as t2 where t2.客户=t1.客户) - sum(t1.货款) over(partition by t1.客户 order by t1.订单号,t1.出库单号) from test1 as t1
select * ,(select sum(定金) from test2 as t2 where t2.客户=t1.客户) - sum(t1.货款) over(partition by t1.客户 order by t1.订单号,t1.出库单号) from test1 as t1
[quote=引用 3 楼 吉普赛的歌 的回复:] 用开窗函数是可以做的。 没太多时间了, 写个大概: select * ,(select sum(定金) from test2 as t2 where t2.客户=t1.客户) - sum(t1.货款) over(partition by t1.客户 order by t1.订单号,t1.出库单号) from test1 as t1
剩余定金不是每次分摊之后剩余的?而是总得?
用开窗函数是可以做的。 没太多时间了, 写个大概: select * ,(select sum(定金) from test2 as t2 where t2.客户=t1.客户) - sum(t1.货款) over(partition by t1.客户 order by t1.订单号,t1.出库单号) from test1 as t1
22,209
社区成员
121,730
社区内容
加载中
试试用AI创作助手写篇文章吧