SELECT concat(STUB,SY,GE,VEND,ITEM) AS 'attrkey', yogurt.IRI_KEY, yogurt.WEEK, yogurt.SY, yogurt.GE, yogurt.VEND, yogurt.ITEM, yogurt.UNITS, yogurt.DOLLARS, yogurt.F, yogurt.D, yogurt.PR, yogurt.Stub, yogurt.UPC, yogurt."Private Label"
FROM IRI01.dbo.yogurt yogurt
WHERE (yogurt.IRI_KEY='535359') ORDER BY STUB, SY, GE, VEND, ITEM