SQL Server查询以从两个表中获取结果 [英] SQL Server Query for getting result from two tables

问题描述

我有两个表:

I have two tables:

1. 
userInfo
(
ScreenName varchar(20),   (pk)
City varchar(50),
Gender varchar(6)
)

ScreenName	City	Gender	Age
Mitesh	孟买	男性	23
Varun	德里/td>	男性	22
Ravi	阿格拉	男性	24
Karishma	班加罗尔	女性	21
Purva	海得拉巴	女性	19

ScreenName	City	Gender	Age
Mitesh	Mumbai	Male	23
Varun	Delhi	Male	22
Ravi	Agra	Male	24
Karishma	Bangalore	Female	21
Purva	Hyderabad	Female	19

2.
friendList
(
senderScreen varchar(20),  (fk userInfo(ScreenName))
receiverScreen varchar(20),  (fk userInfo(ScreenName))
senderRated int,
receiverRated int
)

senderRated 列存储收件人对发件人的评价
和
receiverRated 列存储发件人给接收者的评级.

senderScreen	receiverScreen	senderRated	receiverRated
Mitesh	Varun	5	4
Mitesh	Ravi	1	2
Varun	Karishma	2	NULL

我想要一个查询来给输出类似:

ScreenName	Gender	City	Rating
Varun	男性	德里	3
米特什	男性	孟买	3
Ravi	男性	孟买	2
Karishma	女	班加罗尔	NULL
Purva	女性	海得拉巴	NULL

senderRated column stores the rating that receiver gave to sender
and
receiverRated column stores that rating that sender gave to the receiver.

senderScreen	receiverScreen	senderRated	receiverRated
Mitesh	Varun	5	4
Mitesh	Ravi	1	2
Varun	Karishma	2	NULL

I want a query to give the Output like:

ScreenName	Gender	City	Rating
Varun	Male	Delhi	3
Mitesh	Male	Mumbai	3
Ravi	Male	Mumbai	2
Karishma	Female	Bangalore	NULL
Purva	Female	Hyderabad	NULL

推荐答案

在表上使用联接"的概念.

use concept of ''Join'' on your table.

这篇关于SQL Server查询以从两个表中获取结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！