this should work for you

update tableA

set column_A = column_B

from tableA

inner join tableB

on tableA.codigo = tableB.codigo

and this do the trick also.

god i´m feeling so dumb right now:hehe:

thank you...

If you're using SQL 2008, as per the forum you posted in, try using a Merge statement to get this done:

MERGE INTO table_A

USING tableB

ON table_A.codigo = tableB.codigo

WHEN MATCHED AND...