Member Avatar for springposh 
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?

Edited by Ezzaral because: Added code tags. Please use them to format any code that you post.
  • 3 Contributors
  • 2 Replies
  • 52 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by Netcode
Member Avatar for adam_k

Yes, your query will work.

Member Avatar for Netcode

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.