Update column from column in another table

[Bell1991]

I have two tables:

TableA
name
source
TableB
name
source

I want to update TableA column source with TableB coulmn source..

Please help!

Thanks

 

[DotNetGnat]

Try this:

UPDATE TABLEA SET TableA.source=TableB.source FROM TableB
WHERE TableA.name=TableB.name

-DNG

 

[PHV]

UPDATE TableA INNER JOIN TableB ON TableA.name=TableB.name
SET TableA.source=TableB.source;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886