Selecting Data from first database and Updating in 2nd database

[Cenedra]

Hello everyone,

I looked through the FAQs but couldn't find anything on this.

What I have is a client table in one database, and I need to select ID, RACE from that table in database 1 and update the same client's race in database #2. What is the syntax for doing this?

Thanks a ton
Cen

 

[jabrony76]

Try:

Update T2
    Set T2.Field1 = T1.Field1
From Table2 T2, Table1 T1
Where T2.ID = T1.ID

Hopefully this will help.