.NET, ASP.NET, C#, METEOR JS, RUBY ON RAILS,VB.NET, MS SQL, jQuery, CSS ....

The Blog space reserved for writing my everyday thought about my everyday job. I am.Net developer and my primary writing will be about.Net, c#, vb.net, asp.net and ms SQL. I will try to write about problems and solutions that we meet in our everyday work specially about problems for which answer is hard to find on the internet... I hope it will be a useful place for all of you who need a such sort of information.

Home Uncategories MSSQL : Update a column in one table with values from some other table

MSSQL : Update a column in one table with values from some other table

Nezir Zahirovic 10:54 AM Add Comment Edit

In this post I will show you one useful MS T-SQL Query.

It's about updating a one column from one tables with values from some other table.

The query :

UPDATE t1

SET t1.column1= t2.column2 FROM dbo.someTable1 t1 INNER JOIN

dbo.someTable2 t2 ON t1.joinColumn =t2.joinColumn

We do simple update a column in table someTable1 alias t1 with values from someTable2, we do inner join on join column in this sample that is a joinColumn .

That' all folk's for this time ;) Goodbye ...