0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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), StudentName VARCHAR(30))
 
 INSERT INTO #Student        
 SELECT 'S1', 'Vineeth'
union all
SELECT 'S2', 'Sai'

   

SELECT T.TchrId,T.TeacherName,s.studid, S.StudentName	
FROM #Teacher T
CROSS JOIN #Student S
order by t.tchrid

fork query

edited feb 14 20 anonymous

created apr 22 15 Sarath Avanavu