Thanks so much to all of you.
1) Because of the info from the 3 of you, I got the view I need.
2) This is the first time I've used Stuff XML Path - I don't understand what's going on (even though it's working), hopefully I can take some time this weekend and learn how to use it on a regular basis.

Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…