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