0

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

3
Contributors
3
Replies
21
Views
2 Years
Discussion Span
Last Post by isozworld
0

Or

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

Edited by isozworld: added text in code block

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.