You could add a :counter_cache to your model if you want a simple solution:
http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html On Feb 16, 8:36 pm, Bob Sanders <[email protected]> wrote: > So I have two tables: > > - teams > - players > > I'm trying to find all teams that have no players. I thought this could > work: > > Team.find(:all, :joins => :players, :conditions => ["players.size = ?", > 0] ) > > Of course that's not working for me because I'm mixing the SQL with > Rails. Do you know the proper way to find all teams that have no > players? > -- > Posted viahttp://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 -~----------~----~----~----~------~----~------~--~---
