"Challenged" <sirgoodman@hotmail.com> wrote in message
news:a791c578.0401281733.1b5af187@posting.google.com...
> I have the following table
>
> idProcessMember(PK) idProcessMemberGroup
> 0001 0002
> ----------------------------------------
> 0002 0003
> ----------------------------------------
> 0003 0004
> ----------------------------------------
> 0004 0005
> ----------------------------------------
>
> The table is showing ID 0001 is a member of Group 0002, and then Group
> 0002 itself is now becoming a member of Group 0003 in the next record.
> The pattern continues with Group 0003 becoming a member of Group 0004
> and then lastly Group 0004 becomes a member of Group 0005.
>
> I want to unwind these 4 records into a single record showing the
> associations of the records as follows, 0005,0004,0003,0002,0001.
>
> This said to me that 0001 can not exist without 0005 in this example.
>
>
> This said to me that 0001 can not exist without 0005 in this example.