TRANSFORM First(tab1.VALUE) AS [First-VALUE]  
SELECT tab1.ID_OBJECT, tab1.ID_OBJECT_1 
FROM  ( SELECT prop1.ID_OBJECT as ID_OBJECT_1, obj0.ID_OBJECT as ID_OBJECT, prop1.ID_PROPERTY, prop1.VALUE  FROM STRATEGY_OPER_OBJECT_TREEVIEW AS obj0 INNER JOIN (STRATEGY_OPER_OBJECT_PROPERTY AS prop1 INNER JOIN STRATEGY_OPER_OBJECT_TREEVIEW AS obj1 ON prop1.ID_OBJECT = obj1.ID_OBJECT) ON obj0.ID_OBJECT = obj1.PARENT  WHERE (((obj0.PARENT)='kn62584'))  ) AS tab1  
GROUP BY tab1.ID_OBJECT, tab1.ID_OBJECT_1 
PIVOT tab1.ID_PROPERTY In ('pr9616','pr9617','pr9618','pr9620','pr9621')