Loading

Update Multiple Data from 1 Table to Other Table in Single Query

Ashutosh Tripathi

2 Comments

Join the conversation! Your thoughts help the community grow.

Markandeshwar Jha12y ago
u can also write like thisupdate tableA set tableA.Coursename=tableB.courseName from tableB where tableA.id=tableB.id
ajit kadan12y ago
Great work :)

Update Multiple Data from 1 Table to Other Table in Single Query.

1. Table A

2. Table B

Now We Update in TableA CourseName.

Query

UPDATE TableA SET TableA. CourseName = (select CourseName FROM TableB WHERE TableB.ID_ = TableA.ID)

Output