[eluser]MeanStudios[/eluser]
Got another n00b question if anyone would like to answer.
I've got 3 tables:
- clients <-- Has many user
- users <-- Has one client and many subscriber_group
- subscriber_groups <-- Has one user
How would I run a query that grabs all of the subscriber_groups for the client of the user currently logged in?
So I know the user ID and I need to get all the subscriber_groups attached to all the users under the client that is attached to the user I know the ID of.