How many more levels do you have?

>
>Nothing is ever so simple. I left out another level of complexity, thinking I would be able to do it, but I can't seem to work it out. Here's the next level
>
>

>Salesman Sale Date   P         Q
>Joe      2/4/06      2         7
>Joe      2/4/06      3         8
>Joe      2/4/06      6         6
>Joe      3/4/06      1         5
>Joe      5/4/06      4         2
>Joe      5/4/06      5         9
>Boe      1/4/06      1         5
>Boe      2/4/06      2         6
>Boe      2/4/06      3         7
>Boe      4/4/06      4         8
>Boe      4/5/06      5         9
>Boe      4/5/06      6         0
>Doe      3/4/06      1         7
>Doe      6/4/06      2         8
>

>
>I want the following results:
>
>

>sman   lst_date  Plt  qlt  date-1  p-1  q-1  date-rest  p-rest  q-rest
>Joe      5/4/06    9    11   3/4/06  1    5    {}         11      21
>Boe      4/5/06   11     9   4/4/06  4    8    {}          6      18
>Doe      6/4/06    2     8   3/4/06  1    7    NULL      NULL    NULL
>

>
>'Doe' only has two dates. This can be accomplished with LEFT OUTER JOIN. Otherwise I can't figure out how to handle the salesman level.
>