title: SQL query error 'Subquery returned more than 1 value...' for DELETE FROM IN
body: <p>Query:</p>
  <pre><code>DELETE FROM [dbo].[Time] 
  WHERE UserId IN (SELECT Id FROM [dbo].[Users] WHERE Name like 'test')
  </code></pre>
  <p>sql error:</p>
  <blockquote>
  <p>Subquery returned more than 1 value. This is not permitted when the
  subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as
  an expression.</p>
  </blockquote>
  <p>Others advise to use IN instead of = but query already uses IN</p>
  <p>This happens if [dbo].[Time] have 2 and more rows with the same UserId</p>
  <p>Query looks legit, maybe someone knows what can the problem?</p>