select
hrc6b.mc,hrc21.flh,sum(hrc21.sl) as 销售数量,sum(hrc21.je) as 销售金额 from hrc6b,hrc21
where hrc21.flh=hrc6b.flh
group by hrc6b.mc,hrc21.flhOR
select
MIN(hrc6b.mc) AS MC,hrc21.flh,sum(hrc21.sl) as 销售数量,sum(hrc21.je) as 销售金额 from hrc6b,hrc21
where hrc21.flh=hrc6b.flh
group by hrc21.flh
hrc6b.mc,hrc21.flh,sum(hrc21.sl) as 销售数量,sum(hrc21.je) as 销售金额 from hrc6b,hrc21
where hrc21.flh=hrc6b.flh
group by hrc6b.mc,hrc21.flhOR
select
MIN(hrc6b.mc) AS MC,hrc21.flh,sum(hrc21.sl) as 销售数量,sum(hrc21.je) as 销售金额 from hrc6b,hrc21
where hrc21.flh=hrc6b.flh
group by hrc21.flh
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货