I am trying to write a SQL code to pull all the parts in a chain. For eg., Part A is replaced by Part B and Part B is replaced by Part C and C to D and so on. Is there anyway that I can pull all the parts in that loop at once. A,B,C,D,.....,
All these relationships are stored in one table X as below:
Part Superseding part
Please help and Thanks in advance !