如何在单行中使用多行 [英] How to use multiple row in single row

问题描述

选择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

推荐答案

使用不同的关键字来选择一行中的记录。

如果表之间的关系一对一，它可以显示一行。



选择不同的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 。



查看此查询可能会对您有所帮助。

Use distinct key word to select the record in one row.
It can show one row if the relationship between the tables in one to one.

Select distinct 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.

Check this query it may help you.

这篇关于如何在单行中使用多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！