todaynew 发表于 2016-1-4 14:02
select a.编号,a.客户,b.A货数,c.B货数,b.A金额+c.B金额 as 总价
from 主表 as a
inner join
todaynew 发表于 2016-1-4 14:02
select a.编号,a.客户,b.A货数,c.B货数,b.A金额+c.B金额 as 总价
from 主表 as a
inner join
hshzhq 发表于 2016-1-5 16:29
你好,能不能直接在主表的A货数和B货数的数据类型里面添加select语句,自动计算相同主表主键的对应的子表 ...
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |