level 1
步步爱相随
楼主
select g.ckmc as 仓库名称, b.spmc as 商品名称, a.je as 金额, e.jsmc as 结算名称
from lsxhdmx a
left outer join shangpin b on a.spdm = b.spdm
left outer join lsxhdjs c on c.d**h = a.d**h
left outer join posjs e on c.jsfs = e.jsdm
left outer join lsxhd f on a.d**h = f.d**h
left outer join cangku g on f.dm2 = g.ckdm
where f.rq between '2018-04-01 00:00:00' and '2018-04-30 00:00:00'
order by b.spmc
怎么样达到金额不同但是其他三项相同的行进行合并，并且金额求和
2018年05月17日 14点05分
1
from lsxhdmx a
left outer join shangpin b on a.spdm = b.spdm
left outer join lsxhdjs c on c.d**h = a.d**h
left outer join posjs e on c.jsfs = e.jsdm
left outer join lsxhd f on a.d**h = f.d**h
left outer join cangku g on f.dm2 = g.ckdm
where f.rq between '2018-04-01 00:00:00' and '2018-04-30 00:00:00'
order by b.spmc
怎么样达到金额不同但是其他三项相同的行进行合并，并且金额求和
