Peter - this gets me the result that I want - many thanks! However, this query is in fact part of a much larger and more complex query, so I...

Many thanks Lowell.Unfortunately, the resultset I get is not quite what I am after. I get all the importance levels for each construct, not just the importance level with the...

Tremendous - worked perfectly! 🙂

Thanks very much indeed!

Chris, Peso - Thanks very much for your help and input.

Chris - I have attached a file with some insert statements to add example data that matches what I'm...