Help needed with MySQL query
Posted: Thu Apr 09, 2009 5:28 pm
Having trouble crafting the appropriate query. I'm trying to list all my site's users that are members of a certain group. Here are the relevant tables:
Query I think should work mut which returns an empty set:
Any takers? =)
Code: Select all
member_info
+------------+-----------+----------+
| first_name | last_name | memberID |
+------------+-----------+----------+
| Joshua | Howard | 1 |
| Dayv | Rolfe | 2 |
| kerry | test | 3 |
+------------+-----------+----------+
groups
+---------+-----------+--------------+------------------------------------+----------+
| groupID | moderator | name | description | category |
+---------+-----------+--------------+------------------------------------+----------+
| 20 | 1 | Dayv's Group | A group for Dayv, and no one else. | People |
| 19 | 1 | Dog People | Snouts, Kibble, Corneas! | People |
+---------+-----------+--------------+------------------------------------+----------+
group_members
+-----------------+---------+----------+---------------------+---------------------+
| group_member_ID | groupID | memberID | date_joined | date_left |
+-----------------+---------+----------+---------------------+---------------------+
| 9 | 20 | 2 | 2009-04-09 16:39:01 | 0000-00-00 00:00:00 |
| 8 | 19 | 1 | 2009-04-09 15:33:06 | 0000-00-00 00:00:00 |
+-----------------+---------+----------+---------------------+---------------------+
Code: Select all
select first_name, last_name from member_info, group_members where member_info.memberID = group_members.memberID & group_members.groupID = 20;