在sql server 中找出Picklist的Value

select ent.name as entname, a2.name, a1.value, sm.value, a2.attributerequiredlevelid from ((AttributePicklistValue as a1 INNER join metadataschema.attribute as a2 on a1.attributeid = a2.attributeid) INNER JOIN metadataschema.entity as ent ON a2.entityid = ent.entityid) INNER JOIN stringmap as sm ON ent.objecttypecode = sm.objecttypecode AND a2.name = sm.attributename AND sm.attributevalue = a1.value WHERE sm.langid = '1028' ORDER BY entname, name, a1.value