I'm not quite sure how to get at this data using Actrive record.. I'm trying to get all the appointments made for a particular project. I'm using four models, Projects, Tasks, Resources and Appointments.
The SQL gets me what I'm looking for but how do I do it using Active Record? Select a.* from appointments a join resources r on r.id = a.resource_id join tasks t on t.id = r.task_id join projects p on p.id = t.project_id Where project_id = 1; I can get all the Resources for a project using this but can not get the appointments. I could loop through the resources getting all the appointments and tracking them, but that doesn't seem like the right way to do it. I could also use find_by_sql, but again, that does't seem right. class Project < ActiveRecord::Base has_many :tasks belongs_to :customer has_many :resources, :through => :tasks Any help would be greatly appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---