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