主题：多表汇总问题

期待中 哈哈~！

;with
jh as (
select sum(数量) as 进货数量,单价,sum(金额) as 进货金额 from 进货单 group by 型号，单价
),
xs as (
select sum(数量) as 销售数量,sum(金额) as 销售金额 from 销售单 group by 型号

),
th as (
select sum(数量) as 退货数量,单价 as 退货单价,sum(金额) as 退货金额 from 退货单 group by 型号，单价
),

select jh.型号,jh.进货数量, jh.单价 as 进货单价, jh.进货金额 , xs.销售数量, xs.销售金额,
th.退货数量, th.退货金额 ,　jh.数量 - xs.数量 + th.数量 as 库存数量,　

from jh , xs, th where jh.型号 = xs.型号 and jh.型号 = th.型号

小狐的代码最好理解，不错。

是好理解,可惜在Foxtable中没法执行

如果是SQL Server数据源，应该可以吧？

期待 SQLGroupTablBuilder 的功能完善。编写SELECT 语句太伤脑！

学习学习

学习