Results 1 to 2 of 2

Thread: Help with Query Approach

  1. #1
    Join Date
    Oct 2010
    Posts
    5

    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

  2. #2
    Join Date
    Oct 2010
    Posts
    5
    Help no longer needed. Someone over at webdeveloper.com solved this query for me.

    Terry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •