A More Elegant Way to Do It in Rails

Question

I have the following code:

@countries = Country.find( :all, :order => 'name' ) @countries_with_tips = [] @countries.each do |country| if country.tips.any? @countries_with_tips.push( country ) end end 

I get every country that has at least one piece of advice. The country has some tips and tricks for the country.

It works. But for Ruby, this looks a little unbalanced. Is there a better way?

Thank you in advance

Richard

Answer 1

 @countries_with_tips = Country.joins(:tips).order(:name).uniq 

Answer 2

 @countries_with_tips = @countries.select{|country| country.tips.present? }