question

CanuckBuck avatar image
CanuckBuck asked

Flatten a "daisy-chained" set of records

The data I have is captured as a set of records where a subsequent record is related to the previous record based on it's ID (IDs are sequential but not consecutive) resulting in a daisy-chained set of relationships. I need to flatten data this so that I can find all related records by searching for a given ID e.g.

Thanks in advance for any assistance you can provide.

query-results
capture.png (9.1 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.