If you want to get Salary details instead of designation field then you need to join your SalaryRange Table with Employee table and map the exact matches which you mapped in table relationship.
Ex:
select E.EmpId, E.Ename, S.Salary
from Employee E,
SalaryRange S
Where E.EmpId=S.EmpId