Skip to main content

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.