I want to query to a table to get the salary of an employee then match this salary figure to another table called categories, if found i should take for example let's say the a employees salary is $5000 and after searching through the categories table and found a matching value and the corresponding category to this value is managing director 8.9. What i need to do is pick the value corresponding to managing director 8.0 which is the basic entry for managing directors.
I can get the employe salary and also i am getting the category but getting the value of the basic entry is the problem. The basic entry is always X.0 where X is a variable. Can someone help me on this please?