SELECT
  ID_equipment_unit= STUFF(
         (SELECT '; ' + [Value]
          FROM [Values]
          WHERE ID_equipment_unit = [Values].ID_equipment_unit  and  id_properties='63' or ID_equipment_unit = [Values].ID_equipment_unit  and  id_properties='1061' or ID_equipment_unit = [Values].ID_equipment_unit  and  id_properties='85'
          FOR XML PATH (''))
          , 1, 1, '') ,


        [Values].[ID_equipment_unit],  [Old_Value], [New_Value],[DateTime], [Comment]






FROM  [Values] ,  [History]

where UserLogin='f' and Comment<>''  //условия выборки по таблице History

group by [Values].ID_equipment_unit