Copy data from a table to another one has different structure
- by Kernel
I have two tables with different structure:
TableSource:
intId(not null), txtSummary, strDetail
TableDesc:
guidId(not null), guidFK(not null), Name, Detail
I want to migrate data from two fields of tableSource(txtSummary, strDetail) to
two fields of tableDesc(Name, Detail).
For simply,suppose that guidId and guidFK are auto generation.
I'v tried but not success. Could anyone help me?