Joins Two Table in SQL Server

Accepted 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...

Bineesh Viswanath13y ago

Thank you for the correct Query.

Sunny Sharma13y ago

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.