SELECT WITH PARTIAL MATCH

[tafuri2022]

I have two tables:
"Table a"   column "id_a"  , virtual column "result"
"Table b"   column "multiple_id" , "my_text" 

I would like to obtain in the "result" field all my_text of the rows that meet the condition ...
"id_a" contained in "multiple_id"

Example
"Table a" id_a -> "13"

"Table b"

Record 1 
"multiple_id" --> "1 , 5 , 88 , 13 , 15"
"my_text"-->"test"

Record 2
"multiple_id" --> "1 6, 50, 83 , 8 , 15"
"my_text"-->"test 1"

Record 3
"multiple_id" --> "1 , 9 , 83 , 16 , 13"
"my_text"-->"test 2"

I would like "result" to be :
"test 1, test 3"

Thanks to anyone who wants to help me

[tafuri2022]

correct
I would like "result" to be :
"test , test 2"

[Steve]

SELECT(
  Table b[my text],
  IN([_THISROW].[id_a], [multiple_id])
)

[tafuri2022]

Thanks for the reply. Unfortunately "result" is "test , test 1, test 2"

[Steve]

Looks like a problem with your data.

[tafuri2022]

to be sure of the database, i created a new test app and the result is the same. Maybe I'm wrong but IN() returns only one True and makes SELECT() always True. For this reason the result is not filtered

[tafuri2022]

any idea to solve?

[tafuri2022]

is it possible to solve this problem? how can I do?

[tafuri2022 · Accepted solution]

I share my final solution : SELECT(Table b[my_text],contains([multiple_id],[_THISROW].[id_a]))