select replace(replace(d.DeptCaption, '^^', ' '), ' ', ' ') DeptCaption, d.DeptID, replace(replace(d.DeptCaption, '^^', ' '), ' ', ' ') + ':' + replace(replace(p.ProcessCaption, '^^', ' '), ' ', ' ') ProcessCaption, p.ProcessID from dept d join process p on d.DeptID = p.DeptID order by DeptCaption, ProcessCaption