On 14 Oct 2009, at 16:13, Andrew Stewart wrote: > Anyway, how to get ActiveRecord to use the more efficient and > correct inner join, and how to avoid the duplicating of joins? P.S. This is Rails 2.1.0. Thanks, Andy Stewart