I have the following tables:
TABLE A:
ID NOMBRE
1 A
2 B
3 C
and TABLE B :
ID NOMBRE
1 D
2 E
and I want to insert the data from the "name" columns of both tables in the "name" column of a third table ( TABLE C ).
and I have something like this:
TABLE C
ID NOMBRE
1 A
2 B
3 C
4 D
5 E
I have to clarify that the 3 tables have the same structure. Thanks in advance for the help.