Updating data in table A where record exists in table B 1

[awaria]

I need help with a query. SQL Server 2000

I need to update the field [description] in table A with the
value in field [description] from table B, where record exists in both tables.

Appreciate your assistance.

Thank you,

Andrew

 

[PWise]

Update Tablea
Set Tablea.description=TableB.description
from Tablea
inner join Tableb
on Tablea.xxx=TableB.xxx
And Tablea.yyy=TableB.yyy
And Tablea.zzz=TableB.zzz

 

[gmmastros]

You'll need to define "where record exists in both tables".

The simplest syntax for this would be...

Update TableA
Set    TableA.description = TableB.Description
From   TableA
       Inner Join TableB
         On TableA.IdColumn = TableB.IdColumn

Notice the ON clause. You'll need to define how the rows from each table are matched. Also, it's usually best to write a select query before actually updating the data. Something like this...

--Update TableA
--Set    TableA.description = TableB.Description
Select TableA.IdColumn, 
       TableA.Description, 
       TableB.Description
From   TableA
       Inner Join TableB
         On TableA.IdColumn = TableB.IdColumn

Once you get the select working (to show the correct data), comment the select and uncomment the Update and Set lines.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[awaria]

Thank you for the tips.

I have one more related query to do. How do I select [description] from table B where table B recordID equals table A recordID?

Thanks for all your help

Andrew

 

[jbenson001]

Select b.description
from tableb b
Inner Join tablea a ON a.recordid = b.recordid