title: Deleting rows from two tables
body: <p>I'm trying to delete rows from two different tables at the same time. The tables look something like this:</p>
  
  <pre><code>TABLE - Value
  -----------
  ID
  Field
  &lt;some other stuff...&gt;
  
  TABLE - Srch
  -----------
  Value_ID
  Srch_ID
  &lt;some other stuff...&gt;
  </code></pre>
  
  <p>I'm trying to delete all the rows from <code>VALUE</code> where <code>field</code> is equal to 'SUCCESS' and also delete the rows from <code>SRCH</code> that are linked to <code>VALUE</code> through <code>value_id</code>. In <code>SRCH</code> there can be multiple rows with the same <code>value_id</code>. </p>
  
  <p>What would this SQL statement look like?</p>