多表联合update[mysql/mssql]

mysql

update course a,lesson b set a.CourseName=b.LessonName where a.LessonGuid=b.LessonGuid;

alter table member modify CurrentLevel varchar(50);

mssql

update a set a.CourseName=b.LessonName from course a,lesson b where a.LessonGuid=b.LessonGuid;

alter table member alter column CurrentLevel varchar(50);