How to Update using Joins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to Update using Joins

Author

Topic

itnagaraj
Yak Posting Veteran

70 Posts

Posted - 2010-09-01 : 07:20:17

Table A Contains Following Fields

ID Name

Table A Contains Following Fields

ID

If Both ID's are same,How to update Name in Table A Using Joins

V.NAGARAJAN

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-09-01 : 07:22:18

Here it is

Update a set a.name='something' from tablea a inner join tableb b on
a.id=b.id

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

itnagaraj
Yak Posting Veteran

70 Posts

Posted - 2010-09-01 : 07:31:07

OK.Working Fine and Thanks

quote:
Originally posted by senthil_nagore

Here it is

Update a set a.name='something' from tablea a inner join tableb b on
a.id=b.id

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

V.NAGARAJAN

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-09-01 : 08:09:28

quote:
Originally posted by itnagaraj

OK.Working Fine and Thanks

quote:
Originally posted by senthil_nagore

Here it is

Update a set a.name='something' from tablea a inner join tableb b on
a.id=b.id

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

V.NAGARAJAN

Welcome

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources