I am reading a table from SAP table in Small Business,(OTER). In this table there is a Territory ID, Description, Parent. For example
Territory Description Parent/Subordinate_Object
14 (111) 123-4444 39
15 (222) 222-1234 40
16 (333) 123-4567 41
23 1 14
24 2 15
25 3 16
39 Eastern - US 2
40 Western - US 2
41 Central - US 2
Objective, If the "description" is > 1 <= 15 then use the "Parent" field to get the telephone number. I have used a join to get the description but I can;t get to the telephone number using the parent.