Need help implementing a join

I’d suggest starting by trying to do each search individually to ensure it works the way you want it to. Then you can merge those searches together with :merged with:

Separately, regarding data structure and which way to link datatypes, great post and discussion here: