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 |