Rails - Jan 2006 - Day.find_all_with_appointments - INNER JOIN

Hi list,


Is there a better/simpler way to code an inner join, than the 4 lines below:

     class Day < Foo

         def self.find_all_with_appointments (*args)
             find  :all,
             {  :select => ''distinct foos.*'',
             	:joins => ''INNER JOIN appointments ON
days.appointment_id
= foos.id''
             }.merge (extract_options_from_args!(args))

         end
         has_many    :results  , :class_name => "Result",
:foreign_key
=> "event_id"
     end


:include doesn''t help here, as it produces an outer join.


Alain