title: Deleting From Multiple Tables When There Are Unmatched Records
body: <p>I have a query using mysql that looks like this:</p>
  
  <pre><code>Delete A, B, C 
  FROM FROM  A 
  INNER JOIN B 
  ON         A.a = B.a 
  INNER JOIN C 
  ON         B.c = C.c 
  WHERE      A.a = 'value'.
  </code></pre>
  
  <p>This query works fine if matching records are found.
  But in my case, there could be scenarios where matching records might not be found on table B and C. When this happens I still want the record on table A to still be deleted.
  I have seen the option of deleting from the tables one after the other, but that process is long and hectic.
  Any help on how to go about this?</p>