title: Inner join usage with array
body: <p>I try to make a filter for my project. And I want to learn how can I use array values in inner join. For example I have a query like this.</p>
  
  <pre><code>SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
  FROM Orders
  INNER JOIN Employees
  ON Orders.EmployeeID = Employees.EmployeeID;
  </code></pre>
  
  <p>But I have multiple <code>EmployeeID</code>s in array and I try to make my query like this.</p>
  
  <pre><code>SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
  FROM Orders
  INNER JOIN Employees
  ON Orders.EmployeeID = Employees.1,2,3;
  </code></pre>
  
  <p>this is the wrong way I know but I really don't know the right way to make this query.</p>