Hi team ,
I want to update a column of TABLE 1 , but it should join with TABLE 2 . based some condition it should update .
I have created as below . But it is not working .
Can you please suggest me how can I do it ?
UPDATE Table1
SET Table1.Column1 = 'name'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.name = T2.Name
And T1.id = UPDATE Table1
SET Table1.Column1 = 'name'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '100';