ReCursive/While Loop

ReCursive/While Loop

I am trying to build a view that looks at a table that has three columns;
Building, Lane, Lot. I need to be able to loop through the table
dynamically to display the Building, Lane and Lot all on one row.
Sample:
Building Lane Lot
1 1001 56789
1 1002 12489
1 1002 37159
1 1002 71648
3 3001 27489
3 3001 67154
3 3002 47135
3 3003 84271
3 3003 96472
3 3003 94276
Results
Building Lane Lots
1 1001 56789
1 1002 12489, 37159, 71648
3 3001 27489, 67154
3 3002 47135
3 3003 84271, 96472, 94276
I tried a recursive union but received a message that I had exceded the
max amount of 100. I also tried a loop but it just kept going and did not
concantenate as I had hoped. So far in the table there are over 300 lot
numbers for one building in one lane with the potential of huders more.