joins => [:users_activities, :codes] On Mar 30, 2:03 pm, khagimoto <[email protected]> wrote: > I'm trying to replicate a join in RoR that I can do in SQL very > simply. > > Three tables/models that I have are: Users, Users_Activities, > Activities and Codes. > > Users and Activities have appropriate has_many associations through > Users_Activities model, so it's easy to do a join to get all > activities for a given user. > > Codes, on the other hand, is a different story. It's kind of a > "repository" of all codified data. For example, the Activity table > has a "Activity Type" field that is an integer field. To get the > actual Activity Type name, you have to look it up in the Codes table > like so (joining with user table to get all activities for user id > "1"): > > select activities.*, codes.name from activities, users_activities, > codes > where users_activities.user_id = 1 > and users_activities.activity_id = activities.id > and activities.activity_type = codes.id > > I can do part of the above query if i don't include the Codes table > like so: > > Activity.all(:joins => :users_activities, :conditions => > {'users_activities.user_id' => "1"}) > > How do I also join Codes?
-- 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.
