22,302
社区成员




select sum(cast(数量 as int)),商品 from xq where 配送时间>='2015-10-01' group by 商品
select a.商品 ,sum(isnull(cast(b.数量 as int),0)) as '数量' from spb a left join xq b on a.商品=b.商品
where b.配送时间>='2015-10-01'
group by a.商品
select sum(cast(数量 as int)),商品 from spb where 配送时间>='2015-10-01' group by 商品
select a.商品 ,sum(isnull(b.数量,0)) as '数量' from spb a left join xq b on a.商品=b.商品
where b.配送时间>='2015-10-01'
group by a.商品
select sum(数量) as '数量',商品 from xq
where 配送时间>='2015-10-01'
group by 商品
select COUNT(销量),商品 from spb where 配送时间>='2015-10-01' group by 商品