I have two Tables with the same name, in two differrent database on the same MS-SQL Server 2000, and I wanted to update one colomn in one table from the other database.
X1 Y1 Z1
X2 Y2 Z2
So, the Query should looks like
Update Z2 from Z1.
I hope I make it clear for you guys, please let me know.