The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.
CREATE TABLE #MyTable ( ID INT, Name VARCHAR(200), Courses VARCHAR(200) )
Insert Into #MyTable (ID, Name) Select ID, Name From Student
SELECT ID, CourseID, CourseName INTO #CourseTable FROM Courses c INNER JOIN xferNameCourse xnc ON c.CourseID = xnc.CourseID WHERE nc.ID IN ( SELECT ID FROM #MyTable ) UPDATE mt SET mt.CourseName = s.CourseName FROM #MyTable mt INNER JOIN #Courses c ON mt.ID = c.ID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.