I have a table named table A
My table has 4000 records

My friend has a table name table B
His table has 5000 records

How can I sum Table A + Table B
and obtain a table C with 9000 records ?

Moisés