I already have PHP do this but I am trying to trim the code down a bit. I am still pretty new to SQL.

I have 2 tables one contains users ids and group ids, another contains group ids and group names. I want to run a querry that gets all the group ids for a specific user and then uses that result to get the group name from the other table.

So something like:

SELECT group_name FROM group_table WHERE group_id = (SELECT group_id WHERE user_id=3)

Possible?