倒数第二张图,左右貌似不对
第一张表是交易表,第二张是退款,应该是要这个效果吧
select nvl(a.shoptime,b.shoptime),nvl(a.cnt,0),
nvl(a.money,0),nvl(b.cnt,0),nvl(b.money,0)
from
(select tr.shoptime,count(tr.id) cnt,sum(tr.shopmoney) money
from tb12_shop_trade tr group by tr.shoptime) a
full join
(select re.shoptime,count(re.id) cnt,sum(re.shopmoney) money
from tb12_shop_reback re group by re.shoptime) b
on a.shoptime=b.shoptime