on 2023 Sep 06 5:09 AM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.