SQLServerCentral.com / SQL Server 2014 / Development - SQL Server 2014 / Updating a column in one table from another table / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 09:18:56 GMT20RE: Updating a column in one table from another tablehttp://www.sqlservercentral.com/Forums/Topic1525505-3412-1.aspxJust to be clear, Chris was trying to get the OP to teach themselves how to answer such simple questions on their own instead of making them permanently dependent on the kindness of others on the web. Books Online is a very good tool for learning such basics and more. I'm amazed at how many people that are using SQL Server that don't even know what Books Online is.@gautham.gn,Two questions for you now that you have the coded answer to your question... 1) Do you understand all of the parts of that code and why it works and 2) do you know what Books Online actually is?Fri, 03 Jan 2014 20:42:16 GMTJeff ModenRE: Updating a column in one table from another tablehttp://www.sqlservercentral.com/Forums/Topic1525505-3412-1.aspxUPDATE x SET x.b = y.d FROM TABLE1 x JOIN table2 y ON x.a = y.cFri, 03 Jan 2014 14:56:35 GMTsuneel kamavaramRE: Updating a column in one table from another tablehttp://www.sqlservercentral.com/Forums/Topic1525505-3412-1.aspxCheck in Books Online for UPDATE, specifically UPDATE FROM. If you are still unsure, then take the time to read the posting etiquette article linked in my signature "please read this", and post DDL for your two tables with scripts to populate them with sample data.Mon, 23 Dec 2013 06:28:05 GMTChrisM@WorkUpdating a column in one table from another tablehttp://www.sqlservercentral.com/Forums/Topic1525505-3412-1.aspxWe have two tables with names X and Y.X has a,b columns. And Y has c,d columns.I want to update b column in X table with the values from d column in Y table on condition X.a=Y.c.Can u help me with this query??Thanks,,Mon, 23 Dec 2013 06:03:56 GMTgautham.gn