Hi,Please help me to solve this. Table1 user PID 100 1 100 2 100 3 101 3 101 2 102 1 Table 2 PID Password 1 root 2 root123 3 root543 I need an user who had more than one password as follows. User PID Password 100 1 root 100 2 root123 100 3 root543 101 3 root543 101 2 root123

The kind of answer you are looking for, the below query alone can work fine. select userid, t1.PId,Password from Table1 t1 inner join Table2 T2 on t2.Pid = t1.PId

Hi Sai, Please find below query select userid, t1.PId from Table1 t1 inner join Table2 T2 on t2.Pid = t1.PId group by userid,t1.Pid having count (t2.Pid) >1

select t1.userid, t1.PId,t2. Password from Table1 t1 inner join Table2 t2 on t2.PID = t1.PID where t1.PId

-- Simulate the table DECLARE @Table1 TABLE( Users int, PID int ) -- Simulate the values INSERT INTO @Table1 (Users, PID) VALUES (100, 1), (100, 2), (100, 3), (101, 3), (101, 2), (102, 3) -- Query SELECT Users, PID FROM @Table1 WHERE Users IN (SELECT Users FROM @Table1 GROUP BY Users HAVING COUNT(Users) > 1)

Answers

Query to get who had more than one password.

Sai Reddy

698

1 SQL Server

Hi,Please help me to solve this.

Table1

user	PID
100	1
100	2
100	3
101	3
101	2
102	1

Table 2

PID	Password
1	root
2	root123
3	root543

I need an user who had more than one password as follows.

User	PID	Password
100	1	root
100	2	root123
100	3	root543
101	3	root543
101	2	root123

Query to get who had more than one password.

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)