I have a table with 12 columns tblA and another with 2 columns tblB. Both table have a common column which is something like the primary key. I need to transfer one column from the tblB to tblA.
asked Apr 23, 2015 at 01:13 PM in Default
sounds like you can use the "something like the primary key" column as a mechanism for doing JOIN between the two tables. If I understand this, you want to modify the data in one table based on the data in the other. You can do this using UPDATE ... FROM There are code samples there. You can use your common table as the comparison criteria.
answered Apr 23, 2015 at 04:14 PM
Grant Fritchey ♦♦