I have two tables:

Table 1: variable ID
Column1 Column2
A 1
B 2
C 3

Table2: variables ID + definition
Column1 Column2 (Definition Column1) Column3 Column4 (Definition column3)
A Car 1 Diesel
B Motorbike 2 Electric
C Bycicle 2 Electric
A Car 3 Fuel

Problem: import definition of the variables of table 1, contained in the table2, into table 1

I expect following joining table where the definition of the variables included in table 2 are imported to table 1.

Column1 Column2 Column3 Column4
A Car 1 Diesel
B Motorbike 2 Electric
C Bycicle 3 Fuel