# Multiple join with multiple grouping

**URL:** <https://www.ruby-forum.com/t/multiple-join-with-multiple-grouping/131800>\
**Category:** Rails\
**Created:** [March 13, 2008, 11:54am UTC](https://www.ruby-forum.com/t/multiple-join-with-multiple-grouping/131800 "2008-03-13T11:54:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dino\_d](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@dino\_d](https://www.ruby-forum.com/u/dino_d)\
**Post date:** [March 13, 2008, 11:54am UTC](https://www.ruby-forum.com/t/multiple-join-with-multiple-grouping/131800/1 "2008-03-13T11:54:14Z")

</div>

Hi-

Is there a non-SQL way to accomplish something like

select _, count(_) from A join B join C join D, group by A.field1,  
A.field2

I’d like to then walk through the grouped rows one by one.

Can someone tell me if this is possible and give me a push in the  
right direction?

Thanks,  
Dino