SELECT() from multiple tables with different criteria

[mateo]

Hi there,
I have an issue. I keep trying to connect these SELECT() expressions and cannot find the way. I know how to write a select() with multiple conditions but only for one table. The question is how to write a select() for multiple tables? Is there any way to connect those expressions (below) or maybe to write one select()

SELECT(Komentarze[Email];[ID wiadomości (VC)]=TEXT(Wiadomości[ID wiadomości]);FALSE)

SELECT(Wiadomości[Email];[ID wiadomości (VC)]=TEXT(Wiadomości[ID wiadomości]);FALSE)

[Steve · Accepted solution]

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.

[mateo]

I cannot believe that “+” is the solution
Thanks Steve

[Ing_Fred_Fiifi_]

Please how did u use the Plus (+) in the expression