SOLVED

this (unedited) sql gives the expected result

WITH CTE (id, parent) as

(

SELECT c.id, c.parent

from

(

SELECT DISTINCT(id), parent

FROM

(

select u.id, u.parent

FROM

(

SELECT a.id, a.Loan_ID

, COALESCE(b.id, a.id) AS id_b

, COALESCE(c.Loan_ID, a.id) AS loan_id_c

,...

Hi jcelko212 32090

Thanks for the comments

1. this is the data that is given to me, no control
2. each loan has a key, just not showing it here for legibility, result...

Hi Jeff

thanks for replying, can't say how much I appreciate you taking an interest in this

The proposed output correctly links the id's but (as in my own attempts) I get...

Hi Jeff

thanks for reaching out

I have added a script to load a temp table with a subset of my data.

Note that I have removed [PARENTKEY] as this just is the...