My where statement consists of numbers and I will like to reman these value in the report
Select p.lastname, p.firstname, b.job
from p and b
where b.job in ('28', '30', '45', '2')
I would like the values in the b.job to not be the #s but if it is 28 then Nurse, if 30 then support, if 45 then manager, if 2 then tech.....