search for: user_team

...s to, he can belong to multiple Teams. (Think of this in an athletic context where users are athletes, programs are universities). So my models look something like this: class User < ActiveRecord::Base has_many :user_programs has_many :programs, :through => :user_programs has_many :user_teams, :finder_sql => ''SELECT ut.* FROM user_teams AS ut JOIN user_programs AS up ON up.user_program_id = ut.user_program_id JOIN users AS u ON up.user_id = u.user_id WHE...