I have two tables in FSM called :
Table 1 is that of Person per
Table 2 is the Warehouse wh
Table 1 is the one for "Person per" I need to connect it with table 2 which is "Warehouse wh" with a JOIN and key is in the following field
per.refId = wh.owners[0]
As shown in the picture :
Table 1:

Table 2:

The problem is that since the "wh.owners[0]" field is an array, when executing the query, it does not allow the key to be generated in the query.

Could you say generate the query to link those two tables in FSM if that is your only link key?