Using IN Statement in ExecuteSQL - FileMaker
Let
(
[
idArray = (can use a variable $idarray or field name);
idSQL = "SELECT FirstName FROM users WHERE id IN (" & idArray & ") "
];
ExecuteSQL ( idSQL ; "" ; "" )
)
The whole SQL statement needs to be inserted using a variable for the "IN ()" array to work.