>Tamar,
>
>Here is the code....in a nutshell, I have many places in an application where I have multiple 1-many relationships, and want to bring back data in one shot. I'm not positive of what the GROUP BY would need to be, so I'm guessing it would need to be all three columns.


Thanks, that'll give me something to play with.

Tamar