Okay breaking everything posted in this topic down to one question only:

Look at the following:

  def self.start(teamone, teamtwo)
    week_start_date 
=Time.now.beginning_of_week.to_date.strftime('%Y-%m-%d')
    week_end_date = Time.now.end_of_week.to_date.strftime('%Y-%m-%d')
    compiled_on = week_start_date..week_end_date
    Team.find( teamone, teamtwo,
      :joins => [ :tsrs_ratings, :rushing_offenses ],
      :conditions => { :tsrs_ratings => {:compiled_on  => compiled_on},
        :rushing_offenses => {:compiled_on => compiled_on} },
      :select => "name, tsrs_ratings.tsrs, rushing_offenses.ydspg",
      :order => "tsrs_ratings.team_id" )
  end

Everything about this works fine except for the select option.  I want 
to select name from the teams table, tsrs from the tsrs_ratings table, 
and ydspg from the rushing_offenses table.

How do I combine a multiple select from different tables?

If I have the answer to this question I think I'm going to be just 
dandy.

Thanks!

-- 
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to