I find it hard to build a query. Knowing the nickname of the user, I want to display the name of his group of assignment (attribute name of the table groups). The id attribute of the table groups is related to the attribute table id_object of users_groups.
I thought about this query:
select name from groups where id = (select id_group from users_groups where id_object = (select id_user from users where nickname = "foo");
But is there not something cleaner and simpler than subqueries?
Bookmarks