Naser Gabaj
asked on
Update one table from another table in the same SQL Server
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.
T1.DB1
X1 Y1 Z1
T2.DB2
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.
T1.DB1
X1 Y1 Z1
T2.DB2
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Guys for your instant answer, and I apologize for being late to reply to you.
Kind Regards,
Naser