抱歉...我搞错了..我少了一个条件..

SELECT
a.*,b.*
from
grab.tmp_a as a
inner join
grab.tmp_b as b
on
a.id = b.id and
a.date_a = b.date_b
WHERE
a.date_a > b.date_b;