How can I join these tables?

Did you try:

class Unit < ActiveRecord::Base
   has_many :rooms
   has_many :renters, :through => :rooms, :source => :people

And then do a Unit.find(:first).renters for a list of people that are
renting in that unit?

-christos