A内连接B===>S2区域
SELECT date, ts, country, province, city,ye_no
FROM
(SELECT date, ts, country, province, city,0 AS yes_no
FROM DBa.tba
WHERE (date = today()-1)
)
ALL INNER JOIN
(SELECT date, ts, country, province, city
FROM DBb.tbb
WHERE (date = today()-1)
) USING ( date, ts, country, province, city)
