UPDATE table2 
SET table2col1 = table1.col1, 
table2col2 = table1.col2,
...
FROM table1, table2 
WHERE table1.memberid = table2.memberid

will the above query help me to update fields from one table to fields in another table base on a common id between the two tables?

Yes, your query will work.

Adam_K is correct as usual. Try it out and lets know your result.

Be a part of the DaniWeb community

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