I have two tables which are different with the exception of a single field (column name = "LocationCode").
Both tables can also be joined with a common id field.
I would like to update the "LocationCode" values in one table with the the "LocationCode" of the other table. I can do a relational join on the common id.
It is impractical for me to update one row at a time. How can I update all the rows quickly?
But one more point both tables lies in different database
Varinder Sandhu http://varindersandhus.blogspot.com/
View Complete Post