将nvarchar转换为int以便在视图中连接SQL表

I want to create a view which will display the info from two tables joined by different type fields. The one field is nvarchar and the other one is int. I know i need to convert one type in the other but don't know how to do it. Any help would be greatly appreciated.I want to create a view which will display the