简单验证俩张表的数据是否一致

select a.*
from (select * from tmp.ctr where data_date=2019080102) a
join
(select * from tmp.ctr_b where data_date=2019080102) b
on a.aid=b.aid
and a.price_stgy_id=b.price_stgy_id
and a.bid=b.bid
and a.win=b.win
and a.exposure=b.exposure
and a.click=b.click
and a.active=b.active
and a.billing=b.billing
and a.price=b.price
and a.cpc_multiple=b.cpc_multiple
and a.time=b.time