如何在单行中使用多行

选择a.College_Name，

b.authoritites_Name，b.authoritites_Designation，b.authoritites_Contact

，c.Squads_​​Name

FROM Tbl_Anti_Ragging1 a内部加入Tbl_Anti_Ragging2 b on a.CollegeId = b.CollegeId

内部加入Tbl_Anti_Ragging3 c on a.CollegeId = c.CollegeId

内部加入Tbl_Anti_Ragging4 d on d.CollegeId = a .CollegeId







从Tbl_Anti_Ragging1中选择*

从Tbl_Anti_Ragging2中选择*

从Tbl_Anti_Ragging3中选择*

从Tbl_Anti_Ragging4中选择*



我尝试了什么：



以上是我的单行代码第一表，第二表有2行，第三表有2行，第4表有2行但是当我使用时内部连接然后它创建8行我想知道

如何进行查询意味着我的行只会产生2行



所以请帮助我

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