SELECT 'G', Group_Id as 'Group Id', Group_Name as 'Group Name', (SELECT Group_Name FROM Sales_Inventory_Groups B  WHERE B.Group_Id = A.Parent_ID) as 'Parent Group', Group_Type as 'Group Type'  FROM Sales_Inventory_Groups A