1 2 3 4 | UPDATE student_transaction SET studentid = (SELECT newstudentid FROM student_newid WHERE studentid = student_transaction.studentid) |
Update with select statement
Leave a reply
1 2 3 4 | UPDATE student_transaction SET studentid = (SELECT newstudentid FROM student_newid WHERE studentid = student_transaction.studentid) |