[imtringued]

> So the problem is active record is no good at joins?

You encounter this problem whether you use an ORM or not.