I think you would need to go with the routine to populate a cursor. I can't think of a way that you could use a SQL Select for what you need. The best that I can think of is to join your parent table with your child table on your id field. This will give you one row for each salesperson, but this is not what you wanted. The thing that really makes this impossible is that fact that the number of salespersons for each office can range from 1 - 20.

If anyone else has a way that can utilize a SQL Statement to achieve this, I'd really like to know :).