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.