Sai Reddy

Sai Reddy

  • 1.6k
  • 201
  • 9.7k

Query to get who had more than one password.

Nov 20 2018 7:41 AM
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
 
 
 

Answers (4)