You need to implement a computed column that references a lookup table by using an INNER JOIN against another table