title: How can I create a dropbox & multi-box selection query in SQL Server?
body: <p>I am working on SQL code at a client. I have 3 selection fields on a dropbox, when I provide the first selection, it brings up the correct list.</p>
  <p>But when I make multiple selections, the list disappears, what is the reason, how can I solve it. When I make multiple selections, I want the values I selected to come.</p>
  <p><a href="https://i.stack.imgur.com/Ywsll.png" rel="nofollow noreferrer">When I select only 1 value</a></p>
  <p><a href="https://i.stack.imgur.com/zJVvs.png" rel="nofollow noreferrer">When I choose 2 values</a></p>
  <p><a href="https://i.stack.imgur.com/tEiKj.png" rel="nofollow noreferrer">Here is the screen I want to come when I select 2 values by name</a></p>
  <p>Here is the query I wrote on the client.</p>
  <pre><code>SELECT 
      [.....].UserTableID,
      [.....].Son_Kontrol_No,
      [.....].Son_Kontrol_Adi,
      [.....].Son_Kontrol_Asama
  FROM
      [.....]_SON_KONTROL WITH (NOLOCK)
  WHERE 
      [.....].Son_Kontrol_Adi = '$PSon_Kontrol_Adlari$'
  </code></pre>
  <p>I tried 2 ways and failed.</p>
  <pre><code>SELECT 
      [.....].UserTableID,
      [.....].Son_Kontrol_No,
      [.....].Son_Kontrol_Adi,
      [.....].Son_Kontrol_Asama
  FROM
      [.....]_SON_KONTROL WITH (NOLOCK)
  WHERE 
      $PSon_Kontrol_Adlari$ IN ('Lazer Kesim', 'Kaynaklı İmalat', 'Talaşlı  İmalat')
  </code></pre>
  <p>How can I set up the logic for this? Could you help me?</p>