SELECT * FROM Name JOIN Course ON Course.Id IN (SELECT [value] FROM STRING_SPLIT(Name.CourseId, ','))