9raajf0f

1Table1     |    Table2     |    Table3     |
2Id  Atype  |    Id  Btype  |    Id  Ctype  |
31   A1     |    1   B1     |    1   C1     |
42   A2     |    2   B2     |    2   C2     |
53   A3     |    3   B3     |    3   C3     |
6	
7CREATE TEMPORARY TABLE IF NOT EXISTS 
8  temp_table ( INDEX(id) )
9AS (
10  SELECT t1.id, t1.atype , t2.btype
11  FROM table1 t1
12  left join table2 t2 on t1.id = t2.id);
13
14Result:
15temp_table
16Id  Atype  Btype
171   A1     B1
182   A2     B2
193   A3     B3
20	
21Id  Atype  Btype  Ctype
221   A1     B1     C1
232   A2     B2     C2
243   A3     B3     C3