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);