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 |