On Friday 10 October 2008, Guido Pesch wrote: > Hallo zusammen, > > wie baue ich diese SQL-Abfrage in Rails? > > Select * from USERS WHERE id NOT IN (SELECT user_id FROM PLAYERS) > > Es besteht eine 1 zu 1 Beziehung zwischen User und Player. > > class User > has_one :player
User.find(:all, :include => :player, :conditions => "players.user_id IS NULL") Michael -- Michael Schuerig mailto:[EMAIL PROTECTED] http://www.schuerig.de/michael/ _______________________________________________ rubyonrails-ug mailing list [email protected] http://mailman.headflash.com/mailman/listinfo/rubyonrails-ug
