Table1 (id, country, name, ccy)
Table2 (sId, price)

SELECT
    RTRIM(id) as id,
    country
FROM
    dbo.Table1
LEFT OUTER JOIN
    dbo.Table2 ON Table1.Id = Table2.sId

MNKD US     UnitedStates
928502811   UnitedStates

928502811   UnitedStates
MNKD US     UnitedStates

select trim(id) as id, country
from dbo.Table1 left outer join
     dbo.Table2
     on Table1.Id = Table2.sId
order by id;

SELECT
RTRIM(id) as id,
country
from dbo.Table1
left outer join dbo.Table2 on Table1.Id = Table2.sId
ORDER BY id