I have created 9 tables all holding information about a certain set of people. Each table has the same variable identifying the individual the data belongs to ('participant ID'). That variable has been given key status. Now I would like to combine each table with each other table based on that key variable. But that would mean that each table must be linked to each of the 8 other tables, if I remember correctly from math class this would give 9! lines which is a lot. Can this be executed automatically?
Thanks a lot!