help with sql update statement

[rony001]

hello friends
I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net.

update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = t1.b 

It pastes the column below the existing data. How do I write a query that will replace the existing column? Thanks

[ChrisHunter]

Try this:

UPDATE table1 t1 
    SET table2.b = t1.b
    WHERE t1.a = table2.a 

Let me know if this works or not.

[rony001]

Thank you so much , it worked

[isozworld]

Or

UPDATE t2
SET t2.b=t1.b
FROM table1 t1 inner join table2 t2 on t1.a=t2.a