update column A in table A if table A's column b = table b's column b. 3

[kev510]

Hi everyone. I couldn't sum my question into the subject line. But I'm sure the subject got you opening my thread. Anyway, to explain better, I want to create an update statement so that when (Table A Column A) = (Table B Column A), it would update (Table A Column B) = (Table B Column B)

I already tried

UPDATE TableA SET ColumnB = TableB.ColumnB when TableA.ColumnA = TableB.ColumnA

It gave me an error.. Any help is appreciated!! Thank you.

 

[gmmastros]

UPDATE TableA 
SET    TableA.ColumnB = TableB.ColumnB 
From   TableA
       Inner Join TableB
        On TableA.ColumnA = TableB.ColumnA

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[kev510]

thank you! works wonderfully..