Day.find_all_with_appointments - INNER JOIN


#1

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