title: Inner join on delete query is that bad?
body: <p>I'm currently trying to delete a row from a MySQL table using C#.<br>
  I have two very basic tables: 'head_doc' and 'Doc_details'. Head_doc contains a field called id_doc. Doc_details has also  a field called id_doc and various other fields.<br>
  I'm trying to delete all of the details within Doc_details for a particular id_doc that can be found in head_doc.<br>
  This is my query but I've been told that INNER JOIN on a DELETE query is bad programming. How can I change it?</p>
  
  <pre><code>DELETE h.*,d.* 
  FROM head_doc h 
      INNER JOIN  
      doc_details d
      ON h.id_doc = d.id_doc
      WHERE h.id_doc= id_doc;
  </code></pre>