Mysql query, Create a temporary table

I have two servers. One is local and one external, We have permission to create a temporary table in local server and data access from the external server.

We have to data access between two tables.

table auto created daily like "e_20190412". We want to select one table "e_20190512" and another table select "e_20190623", We want to display data available between tables using group by.

Please help me