Unanswered: Insert Data from One column of Table2 to another Column od Table 1
I have two tables with equal number of records in both the tables.
I need to add a new columnA in TableA and paste the data of ColumnB in TableB.I can create the ColumnA in TableA by a different ALTER sql.But I couldnt use the UPDATE sql because there is no join field between the two tables.
The only relation i need to use is the one to one reference index of the record between two tables.
ColX ColY Colz
xx ee ee
dsf sdf sfd
I need to add a new column A in Table A and move the data from ColB in TableB.