Update with select statement

1
2
3
4
UPDATE student_transaction 
SET studentid = 
(SELECT newstudentid FROM student_newid 
WHERE studentid = student_transaction.studentid)

Leave a Reply

Your email address will not be published. Required fields are marked *