Loading

Query to get who had more than one password.

Sai Reddy

7y821

Hi,Please help me to solve this.

Table1

Table 2

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourav Mukherjee7y ago
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
Laxmidhar Sahoo7y ago
1. select t1.userid, t1.PId,t2.Password from Table1 t1
2. inner join Table2 t2 on t2.PID = t1.PID
3. where t1.PId< 102