title: DELETE rows from multiple tables with JOIN in Mysql
body: <p>I know dozen of questions are available here but I have specific issue which I didn't resolve </p>
  
  <p>I have two tables <code>user_bookmarks</code> and <code>highlights</code>.</p>
  
  <p><code>user_bookmarks</code> contains all the users bookmarks and <code>highlights</code> contains the selected text of particular bookmark.</p>
  
  <p>suppose two users having same bookmarks and both  did some highlight texts.</p>
  
  <p>Now <code>user_bookmarks</code> and <code>highlight</code> tables contains two rows of same <code>bokkmark_id</code>.</p>
  
  <p>if one user delete that bookmark then only one row will be deleted from both tables.</p>
  
  <p>I did some <code>query</code> but didn't success.</p>
  
  <p>here is my query</p>
  
  <pre><code> DELETE FROM user_bookmarks,highlights USING user_bookmarks
   LEFT JOIN highlights ON user_bookmarks.bookmark_id =
   highlights.bookmark_id WHERE user_bookmarks.`user_id` = 39 
   AND user_bookmarks.`bookmark_id`= 1556
  </code></pre>