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)