Update Statement Syntax - 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 2000 Forums

Transact-SQL (2000)

Update Statement Syntax

Author

Topic

Jonny1409
Posting Yak Master

133 Posts

Posted - 2007-10-15 : 06:47:12

Hello,

I have a table with the following fields :

Name = e.g. Joe Bloggs
Age = 27
DOB = 01/01/1980
AreaID = NULL
AreaName = North West

Every person listed in here has a

I have another table which lists the areas (ID and Name)

1 - North
2 - South
3 - North West
and so on....

I would like to update every person's record in table 1, with their team ID as currently it is null.

Obviously I need to get the team ID using table 2 and linking on the name.

What would be the syntax for this please ?

Thanks in advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-15 : 06:51:28

update x
set x.areaid = y.id
from table1 as x
inner join table2 as y on y.name = x.areaname

E 12°55'05.25"
N 56°04'39.16"