Join multiple tables in SynchSets

Hi all,

I have three tables I’d like to join via SynchSets. The three data tables are linked via different Pks/FKs and table2 is linked with both table1 and table3. Table1 and table3 can only be joined via table2 (So basically table1 <-> table2 <-> table3). I’ve added a screenshot of the SynchSet, which is not working properly. Does anybody know how to implement this?

in the “sources” give all three tables IDs. Also in syncMap, you can don’t need to write three syncmaps. you can do something like this: “source”: “table_2”, “targets”: [“table_1”, “table_3”].

see the following screenshot, may be helpful: