Joins Two Table in SQL Server

Question

Sir I now doing the joining of Two table in SQL Server. My Tables are:-1. tbl_Subject(subjectId(pk)subjectNameteacherId(fk))2.tbl_Teacher(teacherId(pk)teacherName) There are 10 subjects with subjectId:-1.Malayalam2.English3.Hindi Teacher with teacherId:-1.Mahesh2.Hameed3.Rao4.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.

Pankaj Pandey · Answer

HELLO BINEESH IF YOU WANT TO SHOW DETAIL OF TEACHER WHO TEACH MORE THEN ONE SUBJECT THEN TRY THIS QUERY. SELECT * FROM tbl_Teacher WHERE teacherId IN( select teacherId FROM tbl_Subject WHERE teacherId IN (SELECT teacherId FROM tbl_Teacher ) GROUP BY teacherId HAVING COUNT(teacherId)>1 ) FOR ANY...

Sunny Sharma · Answer

Hi Bineesh use the below query ------------------------------ SELECT teacherName FROM tbl_Teacher a INNER JOIN tbl_Subject b ON a. teacherId =b. teacherId GROUP BY teacherName HAVING COUNT( subjectName )>1 ------------------------------ Mark it as answer if it helps! Cheers.

Bineesh VP · Answer

Thank you for the correct Query.