Q&A for students, teachers, and linguists wanting to discuss the finer points of the Italian language
CREATE TABLE #Teacher(TchrId VARCHAR(3), TeacherName VARCHAR(30)) INSERT INTO #Teacher SELECT 'T1', 'Mary' UNION ALL SELECT 'T2', 'Jim' CREATE TABLE #Student(StudId VARCHAR(3),TchrId VARCHAR(3), StudentName VARCHAR(30)) INSERT INTO #Student SELECT 'S1' , 'T1' , 'Vineeth' UNION ALL SELECT 'S2' , 'T1' , 'Unni' SELECT T.TchrId,T.TeacherName,S.StudentName FROM #Teacher T CROSS JOIN #Student S WHERE S.TchrId = 'T2'