multiple join with multiple grouping

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