yeah, i’m surprised it works to do the 3 level join. i’ve always just used

subsidiary.mainaddress_text

alone to get the whole address.