You are understanding correctly. The issue is that I dont know how to do it. I realize now that XML PATH is incorrect. But, that was as far as I...

Thanks. Thats close , but not quite it. When you run that query, do you see the last column (relay). Everything in there that is separated by the comma I...

Try this. This is the results I get.

Then scroll all the way to the right. You will see Four Columns (LegName, RelayName, medicalCOnditions, DOB)

What I really NEED is instead...

Anyone want to give this a crack? I would appreciate it. Thanks

I am willing to do this in the client, but frankly, I have not been able to figure out how. I dont really have the option of an y report...

Thanks for taking the time to look. I said Infinite because I don't know the number rows that could ultimately be returned for each LEFT JOIN. In practice, it should...