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
1 2 3 |
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
1 |
UPDATE t1 SET t1.data = t2.data FROM db1.dbo.table1 t1 INNER JOIN db1.dbo.table2 t2 ON t1.ID = t2.ID |