SELECT  'I', Item_Id as 'ItemID' , Item_Name as 'Item' , Item_Code as 'Code' , Price as 'Std Rate' , (Select Brand_Name from Brands WHERE _id= INV.Brand_Id) AS Brand, (SELECT Group_Name from Sales_Inventory_Groups WHERE Group_Id = INV.Group_Id) as 'Group'  FROM Sales_Inventory_Items INV WHERE 1 ORDER BY Item_Name