Thanks, but this doesn't seem to get me the fields from the Codes in
the ResultSet - and it also tries to do
activities.id = codes.id
when it should really be
activities.activity_type = codes.id
will keep looking - thanks though!
On Mar 30, 1:04 pm, Me <[email protected]> wrote:
> 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.
