lyfxlk2009(提问者) 不放单元格可以实现吗？

回复

2022-02-15 13:22 

取消 回复

snrtuemc 回复 lyfxlk2009(提问者) 那就在sql语句中处理好，先把两列数据相乘

回复

2022-02-15 13:24 

取消 回复

lyfxlk2009(提问者) 回复 snrtuemc select a.cRetailCode as 零售单号, a.cToWhCode as 仓库编号, a.dRetailDate as 日期, a.bPayOff as 结算, a.bFAudit as 记帐, a.bPAudit as 验收, a.cMemo as 备注, b.cRetailCode as 零售单号, b.cInvCode as 商品编号, b.cColorCode as 色号, b.cRetailMan as 营业员, b.fDisPrice as 折让价, b.cSizeName as 尺码名称, b.iQuantity as 零售数量 from RetailCH as a left join RetailCDS as b on a.cRetailCode=b.cRetailCode 下面的不会了呢？

回复

2022-02-15 13:32 

取消 回复

lyfxlk2009(提问者) 折让价=单 价

回复

2022-02-15 13:23 

取消 回复

luojian0323 回复 lyfxlk2009(提问者) 那就单价X销量 库存金额应该是个时点数，用计算的方式算库存不准确。

回复

2022-02-15 13:24 

取消 回复

lyfxlk2009(提问者) 回复 luojian0323 直接乘不准确

回复

2022-02-15 13:32 

取消 回复