I have two tables, both looking like
id name value===================1 Joe 222 Derk 30
id name value
1 Joe 22
2 Derk 30
I need to copy the value of value from tableA to tableB based on check name in each table.
Any tips for this UPDATE statement?
You can use the following SQL query if you wish to update table B with the value of value from tableA to tableB based on check name of tables:
UPDATE tableB tB INNER JOIN tableA tA ON tA.name = tB.nameSET tB.value = tA.value
UPDATE tableB tB
INNER JOIN tableA tA
ON tA.name = tB.name
SET tB.value = tA.value
I recommend his SQL Certification course to learn more such tips and tricks in SQL.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.