感谢大佬 ,修改后发现还是报错
elect f.客户,f.所属业务员,本期发货 from (select * from(select SUM(折后金额) as 本期发货,
c.客户简称 as 客户,c.所属业务员 from 发货明细 a inner join 销售发货单 b on a.发货单号=b.发货单号 and b.制单日期>=@开始日期 and b.制单日期<=@结束日期
inner join 客户信息 c on a.客户编号=c.客户编号 and c.所属业务员 like '%'|| @所属业务员 ||'%' and c.客户名称 like '%'|| @客户 ||'%' group by c.客户简称,所属业务员) as d) as f
|