Query to get who had more than one password.

Question

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