You can do this by simple SQL Query by joining two tables by their Id and concatenating the two column values
For Example:
Table1
------
ID ItemName
1 Mango
2 Apple
3 Banana
Table2
------
ID ItemValue
1 100
2 200
3 150
In Sql write as
Select a.ID, a.ItemName+convert(b.ItemValue as varchar) as [ItemWithRate]