youv youv - 5 months ago 7
SQL Question

Update column of one table from same table

I need to update one column of table with other from same table

UPDATE table
SET table1.name = table1.nickname
FROM table
WHERE userid = 5


Is there any problem in my query, please help.

Answer

Looks like you're adding some syntax you don't need...if all the data you need is already there in that table, simply do like so, irregardless of which flavor of SQL (I think--I could be wrong on that part):

UPDATE dbo.tablename
SET columnToChange = columnWithCorrectValue
WHERE userid = 5
Comments