Select a.College_Name,
b.authoritites_Name,b.authoritites_Designation,b.authoritites_Contact
,c.Squads_Name
FROM Tbl_Anti_Ragging1 a Inner Join Tbl_Anti_Ragging2 b on a.CollegeId=b.CollegeId
Inner Join Tbl_Anti_Ragging3 c on a.CollegeId=c.CollegeId
Inner Join Tbl_Anti_Ragging4 d on d.CollegeId=a.CollegeId
Select * from Tbl_Anti_Ragging1
Select*from Tbl_Anti_Ragging2
Select* from Tbl_Anti_Ragging3
Select* from Tbl_Anti_Ragging4
What I have tried:
Above is my Code First Table in my Single Row ,Second Table have 2 row,third table have 2 row,fourth table have 2 row but when i using inner join then it create 8 row i want know
how to make query means my row will make only 2 row
so please help me