cancel
Showing results for 
Search instead for 
Did you mean: 

Could you say generate the query to link those two tables in FSM with an array

0 Kudos
283

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?

Accepted Solutions (1)

Accepted Solutions (1)

Yanik_Kurzawski
Participant

Hello Ruben Dario Salazar Aya,

You can't use "=" in arrays. You have to use the operator "IN". For your quarry that would be:
SELECT p, w FROM Person p JOIN Warehouse w ON p.id IN w.owners;

Best Regards,
Yanik

Answers (0)