SELECT s.Name,s.Segment_ID,sr.domain_name,sr.display_name FROM segment s INNER JOIN Segment_Realm sr ON sr.segment_id = s.segment_id AND s.type_code = 'local' ORDER BY s.Name