34,838
社区成员




select a.[name] 商品, sum(inull(a.[price],0)-isnull(b.[money],0)) 价格 from product a
left join discount b on a.[name]=b.[name]
group by a.[name]
select a.[name] 商品, isnull(sum(a.[price]-b.[money]),0) 价格 from product as a
left outer join discount as b on a.[name]=b.[name]
group by a.[name]