i have one query @recommendations = Cname.select("cnames.name,max(recommendations.count) as rcount"). where(''recommendations.skill= ?'',@key). order(''recommendations.company_id ASC''). group(''recommendations.company_id,cnames.name''). joins(''JOIN recommendations ON cnames.id = recommendations .company_id'') Here this query working in a loop, and this @key in where clause will change depend on the loop,. how to store the each query results, because i need to get that @recommendations.name and @recommendations.rcount results in view? Thanks -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/q_eb4PrwhssJ. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en-US.