I have two databases, one has many fields I need, the other only has one. Is it possible to go through the second database, and update specific rows on the first?
DB1 has many rows, and DB2 has some. Every row in DB2 is in DB1 and they both have the same value for the key row so they can be cross-referenced. What is an easy way to merge DB2 into DB1?