That appears to be 5 tables, but I presume that is just a typo. What are the has and belongs to relationships?
2009/3/5 Pesho Petrov <[email protected]> > > hi, > I have to settle a database query problem, and I am a bit confused. > I have 4 tables: > ----------------- > Members > Groups > Roles > Memberships: member_id, group_id, role_id > Messages: concerned_group_id, content > > If a member is logged in the application, I would like to display the > messages, regarding the groups (if any) of which the member is admin. > (admin is a role) > > I don't know what is the best way to do that, but: > First I can find all Memberships, where the member is admin: > admin_role_id = Role.find_by_name("admin").id > Membership.find(:all, :conditions => ['member_id = ? and role_id = ?', > member.id, admin_role_id]) > > Each from the found Memberships has a group_id > Then how can I find all the Messages, that concern the groups with these > group_id-s? > > Thank you! > -- > Posted via http://www.ruby-forum.com/. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
