Hi,
I have 2 tables on different database. it has different field number and both of them already have data stored . I need to merge them so the field of the destination table has same number (only the field without data).
Does anyone can help how?
create table TableA(
ID Varchar(20),
Name Varchar(30),
Address varchar(50),
City varchar(20)
)
--TableB on DB2
create table TableB(
ID Varchar(20),
Name Varchar(30)
)
select * from TableB
alter table TableB add Address varchar(50);
alter table TableB add City varchar(20)
select * from TableB