title: Delete using 2 tables join and wheres
body: <p>I have 2 tables,</p>
  
  <pre><code>POST (idpost, user, text)
  COMMENT (idcomment, idpost, text)
  </code></pre>
  
  <p>I want to delete all comments with post that have a user like "usertest",</p>
  
  <pre><code>delete from COMMENT c join POST p on c.idpost = p.idpost
  where p.user like 'usertest'
  </code></pre>
  
  <p>How do I do this in subsonic 3?</p>
  
  <p>I tried something like this, but, off course, it doesn't work,</p>
  
  <pre><code>COMMENT.Delete(x =&gt; x.POST.where(y =&gt; y.user == "usertest"));
  </code></pre>