order by mfr_name ---> select mfr.mfr_name, mfr.mfr_id from fsenablers.dbo.tbl_APP_Configurations c inner join tblManufacturers mfr on mfr.mfr_id = c.ownerid where c.applicationcode = '1fsbsr' and c.ownertype = 'mfr' and c.parametername = 'apps.trade.enabled' and c.parametervalue = 'true'