title: Azure SQL optimize IN query
body: <p>I'm trying to optimize the IN query on Azure SQL. This IN query has more than 50k records. With the optimization, I will use the INNER join. This is what I was trying</p>
  <p><code>SELECT incident_nbr from table_name as incidents INNER JOIN unnest(ARRAY['INC123456', 'INC0123456', 'INC432156']) as inc ON inc=incidents.incident_nbr;</code></p>
  <p>But looks this syntax is incorrect. DBeaver shows this error in the SQL script editor.</p>
  <pre><code>org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [102] [S0001]: Incorrect syntax near ')'.
      at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
      at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:577)
      at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:486)
  </code></pre>
  <p>Am I missing anything? TIA.</p>