select distinct p.FormulaTypeID,p.FinancialYearID,p.VersionID,p.ProjectName,f.Formula
from tb_Projects p
inner join tb_FormulaTypes f on p.FormulaTypeID=p.FormulaTypeID
this is still not pulling the right results 🙁
We don't know your tables, your data, your business or your application architecture.
Now try to imagine how difficult it is to help you, given the scant information above.
Please provide some sample data and desired results, along the lines outlined in the link in my signature. We will have this sorted for you very quickly if you take the time to do that.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.