Update command giving error where two databases are involved
update ind13.dbo.mstmassstudents
set ind13.dbo.mstmassstudents.ims=ind13i.dbo.mstmassstudents.ims
from ind13.dbo.mstmassstudents
inner join ind13i.dbo.mstmassstudents on
ind13.dbo.mstmassstudents.uid = ind13i.dbo.mstmassstudents.uid
and ind13.dbo.mstmassstudents.subjectcode = ind13i.dbo.mstmassstudents.subjectcode
and ind13.dbo.mstmassstudents.course = ind13i.dbo.mstmassstudents.course
and ind13.dbo.mstmassstudents.semester = ind13i.dbo.mstmassstudents.semester
I want to update ims field if ind13.dbo.mstmassstudents
from ind13i.dbo.mstmassstudents