0

Please login or register to vote for this query.

(click on this box to dismiss)

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'

fork query

edited nov 28 anonymous

created apr 22 15 Sarath Avanavu