I already have PHP do this but I am trying to trim the code down a bit.
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?