String hql = "select part.ID,part.PartNumber,part.Name,parttype.Name,partkind.Name,
                          partdevice.Name,part.Count,STUFF((SELECT ', ' + cabinet.Name FROM Cabinet as 
                          cabinet,Part_Cabinet as part_cabinet WHERE part.ID=part_cabinet.PaId and cabinet.ID =
                          part_cabinet.CabId FOR XML PATH('')),  1, 1, ''),part.Descript from Part as part,
                          PartDevice as partdevice,PartKind as partkind,PartType as parttype Where
                          part.Kind=partkind.ID and part.Type=parttype.ID and part.Device=partdevice.ID";
Query _q = session.createQuery(hql);