Hi, even after rereading, I have little of a clue what it is exactly that you
are trying to do. It'd help if you provided a more concise, step-by-step
description and/or the smallest unambiguous example of the two tables AND of
what should come out at the end. Also, unless for relatively trivial
problems, the list typically likes to see some own effort and where you are
stuck, rather than to solve the whole problem.
Best,
Daniel