How to add a lambda filter to a join query condition

Hello Xano community, is there anyway to add a lambda filter to a where condition in a join expression?
I mean I have a table (t1) that has a col following the format: "123;222;144" and I have another table (t2) that has a col where each record contains just one identifier like "123", so I need to split by ";" the t1 col and get the first position in order to do the join with t2

I really appreciate your comments.
Thanks!

1 reply