Copy all records data from Table1 into Table2 matching on the ID.
Don't know how to write the query to make this happen. Can anyone help?
Thanks!
Sandy
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
UPDATE Table1
SET Table1.ID = Table2.ID
FROM Table1
INNER
JOIN Table2
ON Table2.ID = Table1.ID