Inner join in appsheet

Hi.
Is it possible to INNER JOIN in Appsheet like it is done in SQL?

Currently I have several tables referenced by a FK and PK, but I don’t understand if it is possible to do an INNER JOIN between them to generate views or update data.

tks

Intersect is equivalent to a SQL inner join.

5 Likes
Select(table[column], 
  IsNotBlank(INTERSECT(
    {List 1},
    {List 2}
  ))
)

I’ve used this for pulling records that share similar values inside lists.

3 Likes

Thanks @Jonathon and @MultiTech_Visions.

I understand that you could use the INTERSECT to extract only one value, but not to query two tables simultaneously. In the same way, your answer serves me for other functions, thank you very much.

1 Like