+2  A: 

I would accomplish this by using an :include. Attempting to do this in Ruby will cause you nothing but grief. You can chain onto an include just fine.

ReinH
hmm, it seems the new rails does the join in memory rather than building it into the sql query. thanks for the tip!
Russ Bradberry