I have one table SCTHIER which contains 4 columns (PARENT, CHILD, PARENT_DESCRIPTION, CHILD_DESCRIPTION).
I would like to query 1 code i.e. PARENT code = 63102001, and get ALL child/sub codes/sub-sub codes/sub-sub-sub codes in just 1 column
So for example in the table below:
63102001 has child/sub codes 105597003, 246636008, 193683001
of which 105597003 has child/sub codes 313165001, 361122008 etc
PARENT SCTHIER.CHILD SCTHIER_1.CHILD SCTHIER_2.CHILD SCTHIER_3.CHILD SCTHIER_4.CHILD SCTHIER_5.CHILD 63102001 105597003 313165001
63102001 105597003 361122008 68777001 232150003 193722001
63102001 105597003 361122008 68777001 75133003
63102001 105597003 361122008 68777001
63102001 246636008 12342234 63102001 246636008 63102001 193683001 232148006 56852002 789675009
63102001 193683001 232148006 77479002
63102001 193683001 232148006 789676005
63102001 193683001 260030003
I would want the output to look something like this:
63102001
105597003
246636008
193683001
313165001
361122008
12342234
232148006
260030003
68777001
56852002
77479002
789676005
232150003
75133003
789675009
193722001
Please bear in mind I'm quite new to Access, and may not know some of the complex areas.
Many Thanks