Anyone got any ideas as to how I can order my query results when using has_and_belongs_to_many. I can''t use the :include option to join tables on the other side of the intermediate habtm table (or at least I can''t figure out how), so I can''t use :order on those table names. The notes for :join say that it is rarely needed, so it makes me believe that''s not the right option??? My query basically joins a bunch of tables together so that I can order the results properly and display a formatted product application listing. Any input would be greatly appreciated.