How to join child array value to another KTable?

If I have a child array (of IDs) in a KTable and I would like to join by ID to another KTable, how would I go about doing this?

I’ve posted the question on StackOverflow if you’d prefer to answer there: ksqldb - How to join child array value to another KTable? - Stack Overflow

Thanks,
Jim