Joins with Pipelines

I am no SQL expert but joins get complicated, Inner, Outer.    Are you trying to do a complex query with parameters from one table matching another?   I do that all the time for unrelated tables where the [Date] is the common piece.

Quickbase will not automatically create table three for you with all possible combinations.   If you create the table, it is not hard to write a Pipeline to iterate through the steps of creating those records.   

For your specific example I would populate the data in Shirts and Names and then create a Pipeline that you fire manually.

Step A is a Search of Shirts

Step B is in the loop of A to Search Names

Step C is in the loop of B to Create a record in the Shirt Name Table with the data from A and B

Then it will loop through all your records.

Initial data creation is easy.  Keeping it correct as you add additional records to either parents will take additional Pipelines.   How much more complex does the process get after that?