Modify view in SQL, so I get the code of the currency from another table

See more:

SQL

MVC

Hello, so i'm currently working on a mvc project using codesmith. Specifically im working on my branch called FmCurrencyRate where i insert the rates of currencies and dates in a grid etc.. I am told to modify the view on sql --> v_fm_currency_rate, so i can get the code of each currency but from another table, which is fm_currency. Which is the correct code to do it?
(p.s the table currency_rate has only int columns, so thats the reason why i need the codes from the other table so in my grid the codes can be shown and not the id's of the currencies)

What I have tried:

ALTER view [dbo].[v_fm_currency_rate] 
as
SELECT id, from_currency_id, to_currency_id, value, rate_date, user_created, date_created, user_updated, date_updated, p2.code as fromCurrencyCode
FROM   dbo.fm_currency_rate p1
INNER JOIN fm_currency p2
ON ...
GO