仅返回与具有多个相关记录的子表相关的表中的1个值

Table A contains an ID that is related to table B. Table B also contains an ID that is related to table C. I need to figure out how to bring back only one value, based on a hierarchy that is defined outside of the tables. For Example: Table A (Devices)Table A contains an ID that is related to table