Join Query in sql

[samsonx]

Hi here am using two tables so i used join query for relation...Now i want to use this join query in update sql command...Is it possible to use it in Update...if yes, please send me a sql query for that

With Regards, Samson

[ToddHileHoffer]

update a set a.value = "value" from TableA a join TableB b on a.id = b.id where b.id = 1

GameFly free trial

[Jaiprakash M Bankolli]

I would suggest write a SP and put the updates in transaction and perform the task

Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com

[ToddHileHoffer]

I would agree.

GameFly free trial