Merge Tables ?

[Eqa Rubi]

Has anyone tried to merge two tables in MySQL ? It seems to be a headache !

What I have are two tables that I want to merge into one.

Lets take an example ...

TABLE A
-----------
|NAME|TOWN|
------------------------
1.|PIET | KLAWER |
2.|JOHN | PARYS |
3.|KOOS| | DURBAN|

TABLE B
----------
TOWN| PCODE|
-----------------
1.KLAWER|1212|
2.PARYS|1234
3.DURBAN|4000

Ok, assuming you understand and my Graphics turn out OK,

I want to now create TABLE C - Which should look like ..

TABLE C
-----------
|NAME|TOWN|PCODE
------------------------
1.|PIET | KLAWER |1212
2.|JOHN | PARYS |1234
3.|KOOS| | DURBAN|4000


Any help will be much appreciated !