Not a clue what you're trying to do. Can you mock it up in Excel and upload a JPG?

This looks like you're building the query in .NET or something....

SELECT ChargeAttribute.Value as 'Prop47',

ChargeAttribute.Value as 'ResentencingDate',

AttributeDef.Description

what's with the .Value stuff?

Could you post a create table script and then a jpg or something showing what you're trying to achieve? I can't make head or tail of your description.