Can someone help me write a query for many-to-many relationship please?

smartcan · #1 (**permalink**) 09-30-11, 17:39

Hi guys!

I'm new to this forum and was wondering if someone can help me out. I know how to write simple queries but having trouble with this:

Assume I have the following Tables

-------------
user
-------------
userid
name
picture
etc.

-------------
group
-------------
groupid
etc.

-------------
group_has_user
-------------
groupid
userid

Let's say I would like to Get array with userid, user.name, and user.picture for all users who are member of groupid 5

How would I write such a query?

r937 · #2 (**permalink**) 09-30-11, 20:01

Quote:

Originally Posted by smartcan

Let's say I would like to Get array with userid, user.name, and user.picture for all users who are member of groupid 5

Code:

SELECT user.userid
     , user.name
     , user.picture
     , user.etc
  FROM group_has_user
INNER
  JOIN user
    ON user.userid = group_has_user.userid
 WHERE group_has_user.groupid = 5

Internet Services

Web Development

Digital Marketing

Consumer Tech