在SQL中将一个值显示为Column和Other AS Value

I have the following query,

我有以下查询,

SELECT  AT.Name AS Name, COALESCE(VAL.Value, VALP.Value) AS Value
FROM    Attributes AT
        LEFT OUTER JOIN AttributesValues VAL ON VAL.AttributeID = AT.ID 
        LEFT OUTER JOIN AttributesValues VALP ON VALP.AttributeID = AT.ID
        LEFT OUTER JOIN Products p ON p.ID = VAL.ProductID 
        LEFT OUTER JOIN AttributesGroups G ON G.ID = AT.GroupID
ORDER BY p.ID;
SELECT