title: How to delete multiple rows in SQL Server
body: <p>I have a secondhand sale car database and four tables with relationships. Same column names have relationships.</p>
  
  <p>Tables are:<br>
  <code>Record</code>: RecID Markname Model...<br>
  <code>Features</code>: FeatureID Featurename<br>
  <code>Marks</code>: MarkID Markname<br>
  <code>Carfeature</code>: CarfeatureID RecID FeatureID</p>
  
  <p>Now, i want to delete a mark from Marks in c#. When i delete a mark, SQL must delete all records who has this mark.</p>
  
  <p>I used a query like that:</p>
  
  <pre><code>DELETE from Carfeature 
   where RecID = (select RecID 
   from Record 
   where Mark = (select markname 
                   from Marks 
                  where MarkID=@MarkID))";
  
  
      string sorgudelmarkfromrecord = "DELETE from Record where Mark=
  (select Markname from Marks where MarkID=@MarkID)";
  
      string sorgudelmark = "DELETE from Marks where MarkID=@MarkID";
  </code></pre>
  
  <p>When i run this, i get an error message like this:</p>
  
  <p><code>Subquery</code> returned <strong>more than 1</strong> value. </p>
  
  <p>This is not permitted when the <code>subquery</code> follows <code>=, !=, &lt;, &lt;= , &gt;, &gt;=</code> or when the <code>subquery</code> is used as an expression.</p>
  
  <p>The statement has been terminated.</p>
  
  <p>So, how can i delete multiple data from a table?</p>