double has_many :through

Is it possible to have a has_many :through on top of another has_many :through?

So, A has_many B through => C. Can I then use that has_many relationship to create another has_many :through? A has_many D through => B? (assuming D has_many B, of course)


I actually tried this last night, but I could not get it to work like this.

Instead I ended up using has_many with :finder_sql but this is less than ideal aswell since you loose a log of methods on it.

If you come up with anything I would also like to know