3

SQL Error The multi-part identifier could not be bound.

I was trying to update data from one table of a database to
another table of another database.

The following TSQL makes sense about what I am talking

UPDATE db1.dbo.table1
SET db1.dbo.table1.data = db2.dbo.table2.data
WHERE db1.dbo.table1.ID = db2.dbo.table2.data.ID

but I was getting a error like The multi-part identifier could not be bound This can be solved byusing aliasing feature of tsql, so I changed my query like this and that solves my problem with
The multi-part identifier could not be bound

UPDATE t1 SET t1.data = t2.data FROM db1.dbo.table1 t1 INNER JOIN db1.dbo.table2 t2 ON t1.ID = t2.ID