Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 777.4k

Joins Two Table in SQL Server

Jun 5 2013 1:41 AM
Sir,  I now doing the joining of Two table in SQL Server.

My Tables are:-1. tbl_Subject(subjectId(pk),subjectName,teacherId(fk)),2.tbl_Teacher(teacherId(pk),teacherName)

There are 10 subjects with subjectId:-1.Malayalam,2.English,3.Hindi
 
Teacher with teacherId:-1.Mahesh,2.Hameed,3.Rao,4.Jasni

in this Mahesh teaching Hindi and English,

The question is :- find out the teacher teaching more than one subject?

I want your help in this problem. send me the right code.

Answers (3)