Help with Query Approach

Can someone point me in the right direction on how to approach this query? I am using MySQL.

I have three tables - users, projects and users_projects. The relationship between users & projects is many to many. I want to be able to select a user, find out which projects he is involved with and then list all the other users that are also involved with those projects.

Any help with the correct approach would be appreciated.

Terry

Help no longer needed. Someone over at webdeveloper.com solved this query for me.

Terry