select segmentId, segment, '' as segmentType, '' as segmentName from tbl_OPR_Segments with (nolock) select * from qrySegments order by segmentType, segmentName