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

Try this:

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

Let me know if this works or not.

Thank you so much , it worked


SET t2.b=t1.b
FROM table1 t1 inner join table2 t2 on t1.a=t2.a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.